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

    Unanswered: selecting a column.....9i

    Hi guys

    Could someone please help me with the query to find out whether a particular column exists in a schema i.e., how to search all the tables present in the schema for a particular column? Thanks.

    Regards
    Shajju

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Look up the view "ALL_TAB_COLUMNS" in the manual

  3. #3
    Join Date
    Aug 2008
    Posts
    464
    Thanks Shammat

Posting Permissions

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