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 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
-
1. Single-ampersand Substitution Variable5m 21sAfter 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
-
2. Substituting Column Names, Expressions, and Text4m 39sIn this video, find out how to use substitution variables for column names, expressions, and text in a SQL statement. FREE ACCESS
-
3. Double-ampersand Substitution Variable3m 49sIn this video, learn how to reuse a substitution variable by making use of a double-ampersand substitution variable in a SQL statement. FREE ACCESS
-
4. DEFINE and VERIFY Commands4m 30sLearn how to use the DEFINE and VERIFY commands to create, assign, and verify a substitution variable when using SQL Developer. FREE ACCESS
-
5. Exercise: Use WHERE and Substitution Variables5mTo 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.
