Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    3

    Question Unanswered: Simple SQL Questions

    Dear members,

    Wish u a Happy and Prosperous New Year

    What are the system tables present in the oracle 9i and how to view all the system tables?

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    The system tables and views are all listed in the reference manual:

    http://download-west.oracle.com/docs...a96536/toc.htm

  3. #3
    Join Date
    Dec 2003
    Posts
    1,074
    Don't forget
    Code:
    SELECT * FROM DICTIONARY;
    -cf

Posting Permissions

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