Select - Dynamic Schema
Posted on 2004-08-10
I want to execute the following select:
Select * From schema.table;
I have this "schema" or username in a table, but how I can do this select ?
I have this username in a variable called "vUser":
Select userId into vUser from oracle_user;
And if I use:
Select * From vUser.table;
Oracle returns an error.
Do I have how to do this ?