Hi Everyone,
Can anyone tell me is it possible to create one LOV which you can select multiple values in Oracle 11g.
Please have a look at the image below.
My requirement is that there is a LOV in which few records are AM shift, few are PM shift and others are NS.
I want to select only the AM or PM or NS shifts.
These User Groups will then be passed onto a sql query in the where clause to obtain a report which can be downloaded as an excel sheet, pdf etc.
Is this possible to do in the LOV. If not, is there any workaround to implement it ?

Thanks
Gautam