Oracle Database 12c R2 SQL: Creating Other Schema Objects


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

Explore the basics of creating and using sequences and views in Oracle Database 12c SQL.



Expected Duration (hours)
0.8

Lesson Objectives

Oracle Database 12c R2 SQL: Creating Other Schema Objects

  • describe views
  • differentiate between simple and complex views
  • create a view
  • modify a view
  • view information using USER_VIEWS
  • define columns as visible or invisible
  • describe sequences
  • demonstrate the use of the NEXTVAL and CURRVAL pseudocolumns
  • use a sequence
  • use the ALTER SEQUENCE statement
  • view sequence information using USER_SEQUENCES
  • create views and sequences

    • Course Number:
    it_dfosfd_15_enus

    Expertise Level
    Beginner