From the course: Oracle Database 12c: Advanced SQL

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Introduction to the Oracle data dictionary

Introduction to the Oracle data dictionary - Oracle Database Tutorial

From the course: Oracle Database 12c: Advanced SQL

Start my 1-month free trial

Introduction to the Oracle data dictionary

- [Instructor] The Oracle data dictionary is a full metadata directory containing important information about what is going on inside your Oracle database. Metadata is information about information and the data dictionary contains all of the information about the Oracle database. The data dictionary contains views, which are created and maintained by the database itself, and present you with information that is useful for both database administrators, as well as database developers. While the Oracle data dictionary is extremely extensive and contains a great set of tables and views, providing extremely verbose and detailed information about your database, from a developer perspective, you can use the Oracle data dictionary to achieve detailed information about the schema objects which exists in your database. For example, the names and specifications of your tables, the indexes created on these tables, the columns and data types of these tables, or information about sequences…

Contents