Searching in complete DB

[qazmlp]

I want to search for a string in the values of all the columns of all
the accessible Tables. How do you do that in SQL(sqlplus)?

[Daniel Roy]

Create a PL/SQL block (or procedure) going through all the VARCHAR2
columns (DBA_TAB_COLUMNS) of all the tables (DBA_TABLES) for all the
users (DBA_USERS). You will need dynamic SQL. Depending on your
version, you might be able to use a function returning a REF CURSOR
(that you can create and manipute in SQL*Plus).

Daniel

qa********@rediffmail.com (qazmlp) wrote in message news:<db**************************@posting.google. com>...

I want to search for a string in the values of all the columns of all
the accessible Tables. How do you do that in SQL(sqlplus)?