Re: PL/SQL HELP: Dynamic TABLE name from SQL query

check out dbmssql.sql in your $ORACLE_HOME/rdbms/admin directory.

Patrick Drouin <patrick.drouin_at_nortel.com> wrote in article <343BD9B3.5304_at_nortel.com>...
> Hello everyone,
>
> Here's my problem : I want to be able to read a table's name from a
> table where I keep some information and then use this information in a
> SELECT statement. Can I get all of my SELECT statement build in a
> variable or in a field in a temp database and then execute the string?
> That sounds easy and I am sure that it can be done in Oracle but I just
> can't figure out how...
>
> Ciao, Patrick
>
Received on Wed Oct 08 1997 - 00:00:00 CDT