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!

For Loop with variable table

771605May 7 2010 — edited May 11 2010
I am trying to use a for loop with variable table name in select statement, but getting a compiler error

for current_aud_row in (select * from ‘||table_name||’ where… )


table_name contains the actual table name

I have to do this as I receive table name as a paramter.
Please Help!!
This post has been answered by Billy Verreynne on May 11 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2010
Added on May 7 2010
11 comments
1,831 views