Here's a really bad query, but one I need to figure out. 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? -Brian -- http://www.freelists.org/webpage/oracle-l