HI all,
I found this question in this blog which exactly talk about the problem I am facing right now. But this question was never answered. That's why I am just re-posting. any help would be highly appreciated.
I am using Apex version 4.2.1
i have a select list which allows user to select multiple values.based on the user selection i need to generate a report table.
i have query like this..
SELECT name FROM LABOR_RATE LR, LABOR_RATES LRS
WHERE LR.LABOR_RATES = LRS.ID
and LRS.BUSINESS_UNIT_INFO = :P5_List(this is the select list ID in my application)
above query works fine if user selects single value from select list.
help me...
if user select multiple values in select list, how to pass multiple values in query........
i'm new to apex and intermediate in writing Oracle SQL query.