Oracle 9i data dictionary definition & informational SQL queries?

Oracle 9i
I am using Oracle 9i on a specific application that was designed back in 2000 -- no supporting documentation, very little training and I'm new to Oracle and sql. I'm currently using Toad for Oracle which allows me to create query templates. Toad for Oracle has existing sql templates which I can modfiy so I'm running queries and in some cases using user_constraints and user_cons_columns to gain some knowledge of this application. MY DILEMMA I can apply the queries and gain the information that I need. but I'm not learning or understanding "Data Dictionary" so I'm looking for someone that could possibly give me a laymans definition and possibly suggest queries and/or or statements that could be useful for my specific situation. Life's tough enough and I really do believe without obtaining an understanding of Oracle I won't have the skills to tackle this challenge. Thanking you in advance for your support and sharing your knowledge. Maxwillalwaysberemembered (MAX = Black German Shepherd who developed Epilepsy & died at the young age of 3)

Software/Hardware used:
oracle 9i, toad for oracle

Answer Wiki

Thanks. We'll let you know when a new response is added.

Oracle uses the term “Data Dictionary” for its system catalogs.
Starting in 1999 with Version 8i, Oracle added the “i” to the version
name to reflect support for the Internet with its built-in Java Virtual
Machine (JVM). Oracle 9i added more support for XML in 2001.
The SQL queries are the most common and essential SQL operations. Via an
SQL query, one can search the database for the information needed. SQL
queries are executed with the “SELECT” statement. An SQL query can be
more specific, with the help of several clauses:

Discuss This Question: 2  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Michael Tidmarsh
    Welcome to ITKE, Maxwillalwaysberemembered! Are you looking for a definition of Oracle 9i? If that's what you're looking for, check out for the latest technology definitions!

    To see how our community works, take a look at our FAQ.
    65,700 pointsBadges:
  • carlosdl
    Hi Maxwillalway, welcome to ITKE. Could you please be more specific about what you are looking for? Also, please let us know the business problem you are trying to solve, so we understand the 'why' of your question and can think of alternative solutions if necessary.
    85,885 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: