On Feb 13, 10:05 am, "Peter Parker" <spider..._at_home.com> wrote:
> Hello,
>
> Is it possible to use pl/sql script to dynamically query all the tables
> owned by a user with a select statement and flag the query that yield
> result? For example, I like to apply the following statement:
>
> select * from [table_name] where id = 'some_id'
>
> to all tables and out put the table_name(s) that satisfies the query. Please
> help. Thanks
Yes. Take a look at EXECUTE IMMEDIATE syntax in PL/SQL
User's Guide and Reference manual.
Received on Tue Feb 13 2007 - 09:14:00 CST
