Working with Substitution

Oracle 12c    |    Beginner
  • 5 videos | 23m 18s
  • Earns a Badge
Rating 4.6 of 212 users Rating 4.6 of 212 users (212)
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
    After completing this video, you will be able to 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. FREE ACCESS
  • Locked
    2.  Substituting Column Names, Expressions, and Text
    4m 39s
    In this video, find out how to use substitution variables for column names, expressions, and text in a SQL statement. FREE ACCESS
  • Locked
    3.  Double-ampersand Substitution Variable
    3m 49s
    In this video, learn how to reuse a substitution variable by making use of a double-ampersand substitution variable in a SQL statement. FREE ACCESS
  • Locked
    4.  DEFINE and VERIFY Commands
    4m 30s
    Learn how to use the DEFINE and VERIFY commands to create, assign, and verify a substitution variable when using SQL Developer. FREE ACCESS
  • Locked
    5.  Exercise: Use WHERE and Substitution Variables
    5m
    To write a SQL statement using the WHERE clause, pass a substitution variable to the SQL statement. 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 on some of our courses, 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
Rating 4.6 of 76 users Rating 4.6 of 76 users (76)
Book Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON
Course Oracle Database 12c R2 SQL: Using the Set Operators
Rating 4.6 of 39 users Rating 4.6 of 39 users (39)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Traditional Data Architectures: Data Warehousing and ETL Systems
Rating 4.5 of 364 users Rating 4.5 of 364 users (364)
Course Aggregating Data
Rating 4.7 of 152 users Rating 4.7 of 152 users (152)
Course Working with SET Operators
Rating 4.6 of 182 users Rating 4.6 of 182 users (182)