Searching in complete DB

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • qazmlp
    #1

    Searching in complete DB

    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)?
    Tags: None
    • Daniel Roy
      #2
      Re: Searching in complete DB

      Create a PL/SQL block (or procedure) going through all the VARCHAR2
      columns (DBA_TAB_COLUMN S) 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@redi ffmail.com (qazmlp) wrote in message news:<db9bbf31. 0307100947.247d 2db4@posting.go ogle.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)?

        Comment

        Previous template Next
        Working...