Chapter 13. The Data Dictionary and Advanced SQL*PLUS Commands

The Oracle data dictionary is a set of tables and views that contains data about the database; it is also sometimes referred to as the catalog. The data dictionary is used internally by Oracle for many purposes; for instance, to determine if a SQL statement contains valid column and table names or to determine the privileges of an individual user. You will find it useful to query the data dictionary because it contains a wealth of information about the database.

You have learned writing SQL scripts in Chapter 2, “SQL: The Basics.” This lab will expand your knowledge of SQL*Plus ...

Get Oracle® SQL by Example, Third Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.