April 2003
Beginner to intermediate
146 pages
3h 2m
English
Content preview from Oracle Data Dictionary Pocket Reference
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 2. Static Data Dictionary Views
While new views are added with every version of Oracle, the static data dictionary views have existed in their current format since Oracle Version 6. These views, which are owned by SYS and built upon tables owned by SYS, provide the ability to access information about database objects.
Categories of Views
Most of the static data dictionary is constructed in a matrix fashion. The first way to categorize data dictionary views is by the breadth of information they cover. Views can be divided into three groups:
- USER_ views
Views that allow you to see objects you own. These view names begin with USER_, as in USER_TABLES and USER_INDEXES.
- ALL_ views
Views that allow you to see objects that you own or that you have been granted privileges to access. These view names begin with ALL_, as in ALL_TABLES and ALL_INDEXES.
- DBA_ views
Views that allow you to see all objects in the database, regardless of who owns them. Primarily, these views are for use by the DBA, and they begin with DBA_, as in DBA_TABLES and DBA_INDEXES.
There are also a handful of other views that provide information of general interest about the database.
The ALL_ views have the same structure as the DBA_ views. The USER_ views have the same structure as the DBA_ views except that they do not include the OWNER column. The views that exist in multiple forms (i.e., ALL_, DBA_, USER_) are listed in this book in the form *_viewname. So, for example, there are three *_TABLES views:
| ALL_TABLES |
| DBA_TABLES ... |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.