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

Oracle SQL 12c
  • 11 Videos | 1h 12m 13s
  • Includes Assessment
  • Earns a Badge
Likes 34 Likes 34
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.