Data Dictionary

Data Dictionary

The data dictionary is full of ‘Metadata’, information about what is going-on inside your database. The data dictionary is presented to us in the form of a number of views. If you are like me, you are a bit forgetful. The data dictionary is a repository of information about the Oracle database, known as metadata. Metadata is ‘information about information,’ and the data dictionary is information about the database. In this section we want to show you how to use the data dictionary to get information on tables.For example, if you create a table in Oracle, metadata about that table is stored in the data dictionary. Such things as column names, length, and other attributes are stored.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s