O'Reilly logo

Oracle® SQL by Example, Third Edition by Alice Rischert

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 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 ...

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