Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is it possible to select multiple values from a List of values (LOV) ?

msJan 28 2022 — edited Jan 28 2022

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 ?

screenshot.png
Thanks
Gautam

Comments
Post Details
Added on Jan 28 2022
1 comment
1,120 views