dynamically query from multip tables

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 Received on Tue Feb 13 2007 - 09:05:04 CST