From the course: Oracle Database 12c: Advanced SQL
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Using the DICT view - Oracle Database Tutorial
From the course: Oracle Database 12c: Advanced SQL
Using the DICT view
- [Instructor] Okay, so now it's time to start accessing the Oracle Data Dictionary. And the first place to start is the special Dict, D-I-C-T View. This view contains information about the Data Dictionary View names that we can retrieve information from. So for example, I can type select, table_name from dict. Dict is short for dictionary. Running this query will return the names of the various Oracle Data Dictionary views. If you are looking for a specific view to see if that view exists or not we can add a where clause to the query, such as where table_name = and then specify the Data Dictionary view name such as ALL_TABLES which is a Data Dictionary view which contains information about all of the tables the current user has access to. And you can see this Data Dictionary view does exist. We'll see how we can query Data Dictionary views in our next video. Note that for most Data Dictionary view names you need to use uppercase letters as the names are all in uppercase. So writing…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.