RE: Dynamic SQL to query all columns on all tables

Take an export and search the file instead.

Waleed

-----Original Message-----
From: Brian Mullin [mailto:bmullin_at_salesforce.com]=20 Sent: Tuesday, April 26, 2005 3:57 PM
To: oracle-l_at_freelists.org
Subject: Dynamic SQL to query all columns on all tables

=20

Here's a really bad query, but one I need to figure out.

=20

I want to query all columns in all tables in a schema for a string value. I think I need dynamic SQL for this, has anyone written such a query before?

=20

-Brian

=20

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l