First page Back Continue Last page Graphics
DICTIONARY View...
Display views that start with “DBA_TAB”
Notes:
The DICTIONARY view contains the name of all dictionary views that are available to you (based on privileges granted). It contains two columns, TABLE_NAME and COMMENTS. The COMMENTS column usually contains a descriptive comment about what the view contains. Unfortunately, sometimes the comment is missing or uninformative.
Since there are so many data dictionary views, it is sometimes difficult to find the view with the information that you need. So if you need information about tables, you could use a query like the one shown above to list all dictionary views containing “DBA_TAB”. Use abbreviations, i.e. “DBA_TAB” instead of “DBA_TABLES”, because many data dictionary views use abbreviations in their names.
Reminder
Note that we have coded DBA_TAB in upper case. This is because all object names in the data dictionary are stored in upper case. If you a used lower case string, e.g. ‘dba_tab’, no rows would be found.