I need to create a value set which selects items from a custom table for certain run no and union it with Select 'ALL' from dual so that when the user selects ALL the program runs for all the items. I tried creating a view of the custom table and then used oracle apps dba
select item from...