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
    FREE ACCESS
  • Locked
    2. 
    Substituting Column Names, Expressions, and Text
    4m 39s
    FREE ACCESS
  • Locked
    3. 
    Double-ampersand Substitution Variable
    3m 49s
    FREE ACCESS
  • Locked
    4. 
    DEFINE and VERIFY Commands
    4m 30s
    FREE ACCESS
  • Locked
    5. 
    Exercise: Use WHERE and Substitution Variables
    5m
    FREE ACCESS

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

COURSE Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language
Likes 36 Likes 36  
COURSE Oracle Database 12c R2 SQL: Creating Other Schema Objects
Likes 15 Likes 15  
COURSE Managing a Database Instance
Likes 18 Likes 18  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Working with Subqueries
Likes 51 Likes 51  
COURSE Data Manipulation Language
Likes 37 Likes 37  
COURSE Data Conversion
Likes 33 Likes 33