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