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 ...
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
