Course details

Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries

Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description

Discover how to use the DEFAULT keyword in INSERT and UPDATE statements. Multitable INSERT statements, the MERGE statement, performing flashback operations, and tracking changes are also covered.

Expected Duration (hours)
1.1

Lesson Objectives

Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries

specify explicit default values in INSERT and UPDATE statements

describe when to use multitable INSERT statements

use the unconditional INSERT statement

use the conditional INSERT ALL statement

use the conditional INSERT FIRST statement

use the pivoting INSERT statement

use the MERGE statement

use the FLASHBACK TABLE statement

track changes in data

use the VERSIONS BETWEEN Clause

perform advanced queries

Course Number:
it_dfosfd_17_enus

Expertise Level
Beginner