O'Reilly logo

Oracle SQL, A Beginner's Tutorial, Second Edition by Djoni Darmawikarta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 13

The Data Dictionary

The data dictionary of a database contains data about the data in the database. This data about data is also known as metadata. The data in the data dictionary is stored as tables. As such, you can use your SQL skills to query the data dictionary of your database. The tables and their data are maintained by the Oracle database system. You should not access the dictionary tables directly. Instead, use the Oracle-supplied views of the dictionary.

This chapter explores the views in the data dictionary.

The Dictionary View

The dictionary view is one of the views in the data dictionary. It returns all the views available in your dictionary. The view has two columns and can have over 650 rows.

The query in Listing 13.1 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required