Search for tablename and column name for one value across 1 database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • daves1
    New Member
    • Sep 2008
    • 4

    Search for tablename and column name for one value across 1 database

    Hi,
    I want to search for the table name and column name that have the value "ABC" .

    Any idea with where i could start with this one?

    thanks.
  • Dave44
    New Member
    • Feb 2007
    • 153

    #2
    yep, within each schema look in user_tables or user_tab_column s. Or join the two on tablename and look for what you need.

    Comment

    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119

      #3
      dictionary can provide you information regarding the structure of the objects not the containing data.

      Comment

      • AdusumalliGopikumar
        New Member
        • Aug 2007
        • 42

        #4
        select * from user_tables where table_name like 'ABC%';

        This Query will give you all the tables having ABC as it name

        select * from user_tab_cols where column_name like 'ABC%';

        This Query will listy all the columns having ABC in the column name

        Comment

        Working...