Working with Substitution
Oracle 12c
| Beginner
- 5 Videos | 23m 18s
- Earns a Badge
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 statementuse substitution variables for column names, expressions and text in a SQL statementreuse 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 Developerwrite a SQL statement using the WHERE clause and pass a substitution variable to the SQL statement
IN THIS COURSE
-
1.Single-ampersand Substitution Variable5m 21s
-
2.Substituting Column Names, Expressions, and Text4m 39s
-
3.Double-ampersand Substitution Variable3m 49s
-
4.DEFINE and VERIFY Commands4m 30s
-
5.Exercise: Use WHERE and Substitution Variables5m
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.