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