Oracle Database 12c R2 SQL: Managing Schema Objects

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