Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: searching for a specific column in a schema

    Hi

    Can someone help me with the SQL to find which table contains a specific column in oracle 9i? Apologies if the question is too open.

    Regards
    Shajju
    Last edited by shajju; 11-07-09 at 03:58.

  2. #2
    Join Date
    Mar 2007
    Posts
    623
    Hi,
    it would be nice if you precised, with what is the required column specific. E.g. with its name, data type, number of occurrences in different tables, or something totally different?

    Anyway, all column properties mentioned by me for current user are available from querying USER_TAB_COLUMNS view. Similarly, ALL_TAB_COLUMNS shows all columns the current user is privileged to see, DBA_TAB_COLUMNS covers whole database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •