December 2010
Intermediate to advanced
713 pages
19h 33m
English
![]()
The previous chapters in this book focus on topics such as managing users, basic security, tables, indexes, and constraints. This chapter focuses on extracting information from the data dictionary regarding those topics. Each of the sections in this chapter contains one or more SQL queries that demonstrate how to extract information from the data dictionary regarding a specific type of database object.
The Oracle data dictionary houses information about all aspects of the database. It stores critical information about the physical characteristics of the database, users, objects, and dynamic performance ...
Read now
Unlock full access