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 O’Reilly online learning.

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