This content has been marked as final. Show 6 replies
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.