I need to define a page source with conditions in the where statement.
I.E. Select * from myTable where myField = myVar1.
The where statement should only be used, if a textbox :myBox contains a specific value.
The content of myVar1 should also vary with regard to the value in :myBox.
How can I do this?
Thanks in advance for you help.
Edited by: kps204020 on 05.10.2012 16:09
Select * from myTable where (myField = :P1_PAGE_ITEM or nvl(:P1_PAGE_ITEM,-1) =-1)
Assumming myField is a numeric field and P1_PAGE_ITEM is your myVal1 and is suppose to be a number. I would should you use bind variables for security reasons.