Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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