Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to run a SQL query which is stored in a column using PL/SQL?

Mohan 1978Dec 9 2008 — edited Dec 9 2008
Hello

I have a table A and one of the column values is select * from emp where empno :=xyz;

Now I would like to call this SQL query using a cursor in PL/SQL and run this for all the empno's and insert them into a temp table.

Can anybody help me in writing this PL/SQL query?

With Regards,
Mohan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 6 2009
Added on Dec 9 2008
14 comments
853 views