first you would need to create a function that will break up the string to individual records into a user defined type.
so what would happen is
select * from emp where empno in (select column_value from the (select cast (ParseStringToTable(:emplist,',') as StringTable from dual))
emplist...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.