A Look Inside Oracle's Data Dictionary
The examples in this section show you how to retrieve information from the data dictionary and are applicable to most relational database users, that is, system engineer, end user, or DBA. Oracle's data dictionary has a vast array of system tables and views for all types of database users, which is why we have chosen to explore Oracle's data dictionary in more depth.
User Views
User views are data dictionary views that are common to all database users. The only privilege a user needs in order to query against a user view is the CREATE SESSION system privilege, which should be common to all users.
Who Are You?
Before venturing into the seemingly endless knowledge contained within a database, you should know ...
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition 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.
