Can I use a variable name in a select statement inside a PL/SQL block. I was wondering if I could pass a variable name for the tablename in a select query.
Thanks in advance for any help.
Printable View
Can I use a variable name in a select statement inside a PL/SQL block. I was wondering if I could pass a variable name for the tablename in a select query.
Thanks in advance for any help.
Sure you can. You will have to use a feature called Native Dynamic SQL. See ( http://www.oracle.com/oramag/oracle/00-nov/o60sql.html )
Thank you.
That was an interesting URL that you had pointed to. That could have satisfied my requirements, had we been using ORacle8i. Is it available on 8.0? It doesn't seem to recognize the 'EXECUTE IMMEDIATE' command. Or is there something that I am missing. Or is there specific setup needed to use this feature?
see whether your version has DBMS_SQL package, which supports dynamic sql including DDLs.
Thank You. It worked.