dynamically query mutiple tables

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 Mon Feb 12 2007 - 22:35:42 CST