Working with Substitution

Oracle 12c    |    Beginner
  • 5 Videos | 23m 18s
  • Earns a Badge
Likes 146 Likes 146
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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 57 Likes 57  
Likes 57 Likes 57  
Likes 223 Likes 223