passing multiple values for a single parameter in oracle apps Reports:
Here Comma delimited Multiple values parameter considering as a single sting .
Example : If passing parameter value as 'ABC,ABCD' This entire sting consider as a single string but i want to use this as a comma delimited like in ('ABC','ABCD')
By using below Example it could be Rectified.
SELECT * FROM XX_TABLE WHERE XX_COLUMN in (SELECT REGEXP_SUBSTR (value,'[^, ]+',1,LEVEL) value
FROM (SELECT 'ABC,ABCD' value FROM dual)
connect BY REGEXP_SUBSTR (value,'[^, ]+',1,LEVEL) IS NOT NULL) --ABC,ABCD
Here Comma delimited Multiple values parameter considering as a single sting .
Example : If passing parameter value as 'ABC,ABCD' This entire sting consider as a single string but i want to use this as a comma delimited like in ('ABC','ABCD')
By using below Example it could be Rectified.
SELECT * FROM XX_TABLE WHERE XX_COLUMN in (SELECT REGEXP_SUBSTR (value,'[^, ]+',1,LEVEL) value
FROM (SELECT 'ABC,ABCD' value FROM dual)
connect BY REGEXP_SUBSTR (value,'[^, ]+',1,LEVEL) IS NOT NULL) --ABC,ABCD
