It’s very common use case where we want to pass comma separated value for WHERE clause as IN operator. Today I will explain in very simple way to overcome this issue. Here I am using very simple function INSTR in place of IN operator.
Let’s take an example. Create a View Object using Employees table with following query.
select employee_id,first_name,last_name,email,phone_number from employees where INSTR(:str,employee_id)<>0
In following example, I have using bind variable STR which contains comma separated value.
Run Application Module to Check Query Result
Check out query Result.