Course Description
Discover how to use the DEFAULT keyword in INSERT and UPDATE statements. Multi-table INSERT statements, the MERGE statement, performing flashback operations, and tracking changes are also covered.
Learning 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