01) Briefly describe what is the benefit to use SQL*Plus substitution variables?
Use SQL*plus substitution variables to:
Store values temporarily.
Single ampersand (&)
Double ampersand (&&)
DEFINE command
Pass variable values between SQL statements.
Dynamically alter headers and footers.
02) Briefly describe what is the benefit to use the ‘&’ substitution variable?
03) Briefly describe how to using character and date values with substitution variables in SQL?
04) Briefly describe where you can use substitution variables as supplement?
05) Briefly describe how you can define substitution variables in SQL*PLUS?
In SQL*Plus substitution variables can be used to customize reports and can be used instead of hard-coded text. Substitution variables can interact with bind and system variables. Substitution variables that have values stored are said to be defined. Substitution variables references have an "&" or "&&" prefix.
06) Briefly describe DEFINE and UNDEFINE commands in SQL*PLUS?
DEFINE COMMANDS: -
Use the DEFINE command to explicitly create substitution variables.
Using DEFINE with no arguments lists all defined substitution variables. Any variable that DEFINE lists is said to be defined.
The DEFINE command only ever creates variables with type CHAR.
UNDEFINE COMMANDS: -
Use UNDEFINE to remove a defined substitution variable.
Any variable not listed by DEFINE is said to be undefined.
07) Briefly describe when you want to use the ‘&&’ substitution variable in SQL*PLUS?
Use the double-ampersand (&&) if you want to reuse the variable value without promoting the user each time.
08) Briefly describe what the VERIFY command in SQL*PLUS use for?
Use the VERIFY command in SQL*Plus to toggle the display of the substitution variable before and after SQL*Plus replaces substitution variables with values.
09) Briefly describe how you can customize the SQL*Plus environment?
You can control the environment in which SQL*Plus