Anita.I wrote:Not possible and also feasible. Use cursor and insert data in your block.
I have a LOV in which I would like to include a 'Select All' record. Selecting this would select all the records in the LOV and place it in the tabular form .
Is this possible/feasible?
and when 'ALL' is selected you can query like this:
select 'ALL' employee_name from DUAL union select employee_name from employee
Edited by: indra budiantho on Apr 4, 2013 4:25 PM
select employee_name from employee where employee_name = decode(:control.lov,'ALL',employee_name,:control.lov)