Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views 


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

Explore the basics of data dictionary views. Discover how to create views on tables. Synonyms, sequences, and indexes, and how to create them is also covered.



Expected Duration (hours)
0.6

Lesson Objectives

Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views 

  • provide an overview of data dictionary views
  • demonstrate when to use the USER OBJECTS view
  • demonstrate when to use the ALL_OBJECTS view
  • query a data dictionary view for table, column, and constraint information
  • add a comment to a table and query the data dictionary view for comment information
  • work with dictionary views

    • Course Number:
    it_dfosfd_07_enus

    Expertise Level
    Beginner