Hi,
I have a SQL query which has multiple IN clause for validation . I am trying to implement it using DB adapter but it's not working. Usually to use IN clause in DB adapter i will use sub-query like
IN (WITH VALUELIST AS (SELECT ? val FROM dual) SELECT SUBSTR(val, (decode(LEVEL, 1, 0, instr(val, ',' , 1, LEVEL -1)) + 1), (decode(instr(val, ',' , 1, LEVEL) -1, -1, LENGTH(val), instr(val, ',' , 1, LEVEL) -1)) - (decode(LEVEL, 1, 0, instr(val, ',' , 1, LEVEL -1)) + 1) + 1) a FROM VALUELIST CONNECT BY LEVEL <= (SELECT(LENGTH(val) -LENGTH(REPLACE(val, ',' , NULL))) FROM VALUELIST) + 1)
But this is not working for multiple IN clause scenario.
SQL Query: SELECT column_name(s)
FROM table_name
WHERE column_name IN (SELECT STATEMENT) AND column_name IN (SELECT STATEMENT) AND column_name IN (SELECT STATEMENT)
Please help me to implement multiple IN clause using DB Adapter