Working with Substitution

Oracle 12c
  • 5 Videos | 23m 18s
  • Earns a Badge
Likes 40 Likes 40
Learn how to build dynamic queries in Oracle Database 12c using substitution variables and the DEFINE and VERIFY commands.

WHAT YOU WILL LEARN

  • describe the use of substitution variables in a SQL statement and use a single-ampersand substitution variable to provide a value in a SQL statement
    use substitution variables for column names, expressions and text in a SQL statement
    reuse a substitution variable by making use a double-ampersand substitution variable in a SQL statement
  • use the DEFINE and VERIFY commands to create, assign, and verify a substitution variable when using SQL Developer
    write a SQL statement using the WHERE clause and pass a substitution variable to the SQL statement

IN THIS COURSE

  • Locked
    1. 
    Single-ampersand Substitution Variable
    5m 21s
  • Locked
    2. 
    Substituting Column Names, Expressions, and Text
    4m 39s
  • Locked
    3. 
    Double-ampersand Substitution Variable
    3m 49s
  • Locked
    4. 
    DEFINE and VERIFY Commands
    4m 30s
  • Locked
    5. 
    Exercise: Use WHERE and Substitution Variables
    5m

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.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 51 Likes 51  
Likes 37 Likes 37  
Likes 33 Likes 33