By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

Searching in complete DB

P: n/a
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)?
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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)?

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.