Each data dictionary view has three different versions:
To find out information about the tables in an Oracle database, you normally use the
This view includes 39 different columns, with information about a wide variety of characteristics of the table. Many of these attributes will only be meaningful when you learn all the intricacies of the Oracle database.
The most commonly used columns are:
You can use the Schema Manager to display the names and attributes of tables,
but it is just as easy to use SQL statements to query the data dictionary views, as shown in the Slideshow that follows:
Querying Data Dictionary
The next lesson explains how to get information about the columns in a table from the data dictionary.