From the course: Oracle Database 12c: Advanced SQL
Unlock the full course today
Join today to access over 23,700 courses taught by industry experts.
Introduction to the Oracle data dictionary - Oracle Database Tutorial
From the course: Oracle Database 12c: Advanced SQL
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.