Re: IN Subquery on Collection

You can use table function to treat your cursors as table.

For example:

INSERT INTO my_emp SELECT * FROM emp WHERE ename IN (select column_value from table(l_table)); Received on Thu Feb 01 2007 - 00:12:28 CST