Course 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.
Learning 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