DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Display all record in case of null parameter OR selecting "ALL"

443251Feb 4 2009 — edited Feb 4 2009

hi all,

I want to show the all records in the report in case the user give empty parameter Or "ALL" from the parameter list.

I used such the way in the query:

select item
from item_master
where ITEM_ID = NVL(:P_ITEM,ITEM_ID);

its working good but now I want to give the "ALL" in the list of parameter form. so when the user select the "ALL" then the all items to be displayed.

thanks

Muhammad Nadeem
nadeem14375@gmail.com