This content has been marked as final. Show 6 replies
1 person found this helpful
select ... ... and (current_req_status = :block1.req_status or :block1.req_status = 'ALL')
It depends on your Forms version. Any version of Forms below release 10g R1 (9.0.4.x.x) does not support the CASE function. I think the DECODE (as InoL demonstrated) is a good choice.
Edited by: CraigB on Apr 10, 2012 11:39 AM
In the database column not having "ALL" value inside. so the match does not return any values.
My LOV has "A1,A2,A3,A4,....ALL" . the database column having "A1,A2,A3,A4.......". here no "ALL" value.
So if user select "ALL" option from this LOV, that means select all vaules from the database (A1,A2,A3,A4......)..
If user select A1 from the lov the select query include only the matched
column values.from example,
If user select "ALL" option then no need for above condition in the where clause so that query returns all the rows from the database column.
select.... where nvl(database_column,'X')= nvl(:Block1.LOV_value)
hope I've clearly explain my requirement.
Now only i come to know this. thank you lot.
It depends on your Forms version. Any version of Forms below release 10g R1 (9.0.4.x.x) does not support the CASE function.
Did you even try InoL's solution? Its the correct one.
Something like this?