Oracle Database 12c R2 SQL: Managing Schema Objects    


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Explore how to work with constraints and alter existing objects in Oracle Database 12c. Working with external tables and naming an index at time of creating a PRIMARY KEY constraint is also covered.



Expected Duration (hours)
1.2

Lesson Objectives

Oracle Database 12c R2 SQL: Managing Schema Objects    

  • add a constraint
  • drop a constraint
  • delete child rows using the ON DELETE CASCADE and DELETE SET NULL clauses
  • use the CASCADE CONSTRAINTS clause
  • disable and enable constraints
  • describe indexes
  • create an index
  • retrieve index information using USER_INDEXES
  • create a temporary table
  • describe the benefits of external tables
  • create external tables using the CREATE TABLE statement
  • query external tables
  • work with database objects
  • Course Number:
    it_dfosfd_08_enus

    Expertise Level
    Beginner