select  b.description,sum(TRANSACTION_QUANTITY),b.segment1
from MTL_MATERIAL_TRANSACTIONS a,mtl_system_items_b b
where a.inventory_item_id=b.inventory_item_id and a.organization_id=b.organization_id and a.organization_id=: P1 and b.segment1 between : P2 and : P3 
group by b.description ,b.segment1

انا كتبت الاستعلام دة بس عايز اليوزر لما يسيب : P2و : P3
فاضى يجيب كل الداتا
ازاى اقدر اعملها
مثلا
يدخل :P2 ويسيب : P3 فاضى فيجيب
كل الداتا من : P2 حتى الاخر

hi
please accept me friend for you
this is very simple query you should be in the next time depend on your selfe more
ok

((b.segment1 between : P2 and : P3) or( : P2 is null ) or( : P3 is null ))

تم تعديل 19 أكتوبر 200916 سنة بواسطة topone

i made that before you said to me
but it doesnt work

down

تم تعديل 19 أكتوبر 200916 سنة بواسطة PALI.ORACLE

جرب هيك:

Nvl(b.segment1,0) between Nvl(:P2, Nvl(b.segment1,0)) and Nvl(:P3, Nvl(b.segment1,0))

i give you sir statment 100% it's correct
just try tested

select b.description,sum(TRANSACTION_QUANTITY),b.segment1
from MTL_MATERIAL_TRANSACTIONS a,mtl_system_items_b b
where a.inventory_item_id=b.inventory_item_id and a.organization_id=b.organization_id and a.organization_id=: P1 and ((b.segment1 between P2 and P3) or ( P2 is null ) or( P3 is null ))

this command stander in oracle reports not from my head


sir put : besied eash parameter

and i am sorry mr PALI.ORACLE your statment its do delay for the report in the system why you used nvl
its not good way

NP

االسلام عليكم
ايضا
ايضا يمكنك النظر في مثل هذا المثال
http://www.araboug.org/ib/index.php?s=&amp...st&p=166949

موفقين

i try to use it again but it give me null result
not all as i want

اقتراح اخر ... بالاضافة للحلول السابقة الصحيحة

يتم اعداد قيم اوليه ال p1 وp2
if p1 is null then p1:=0
if p2 is null then p2 := 99999999

او

and ( b.segment1 between nvl(p1,0) and nvl(p2,99999) ) x