Re: Searching in complete DB

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 11 Jul 2003 09:48:49 -0700
Message-ID: <3722db.0307110848.18be5300_at_posting.google.com>

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

qazmlp1209_at_rediffmail.com (qazmlp) wrote in message news:<db9bbf31.0307100947.247d2db4_at_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)?
Received on Fri Jul 11 2003 - 18:48:49 CEST

This message: [ Message body ]
Next message: Andre: "dbms_output.putlin show up AFTER completion???"
Previous message: Daniel Roy: "Re: dbms_output.putlin show up AFTER completion???"
In reply to: qazmlp: "Searching in complete DB"
In reply to qazmlp: "Searching in complete DB"
Next in thread: sybrandb_at_yahoo.com: "Re: The dreaded TNS-12500 error."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message