What are the types of substitution variables?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What are the types of substitution variables?
Rating:
Depending on the number of ampersands (&) preceding the substitution variables, substitution variables are of two types: single-ampersand (&) substitution variables and double-ampersand (&&) substitution variables.
A single-ampersand substitution variable prompts the user to enter a value for each occurrence of the variable in the script or the SQL statement. On the other hand, a double-ampersand substitution variable prompts the user to enter a value only once, regardless of the multiple occurrences of the variable in the script or the SQL statement.
Rating:
Was this information helpful?
Other articles
- What is schema?
- What are the guidelines for naming a column?
- What are group functions?
- How many types of indexes can be created?
- How is top-n analysis performed?