O'Reilly logo

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts by John Adolph Palinski

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

Oracle’s Data Dictionary

After the object is created and stored in the database, the developer may have a need to identify objects or to determine attributes concerning the object. Fortunately, Oracle has an extensive data dictionary that can be used to identify the objects. This section will introduce you to this dictionary.

The SYS user (the master user account) owns the actual data dictionary tables. The tables contain all of the information that Oracle needs to manage the Oracle installation. The tables are not generally accessed because they are hard to use. Oracle has created a number of views, or virtual tables, that make the data dictionary tables more understandable. Examples of information stored in these views are table names and ...

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