Oracle
Substitution Variable
Figo Kim
2006. 8. 28. 22:14
- single-ampersand(&) or double-ampersand(&&)
& : temporary
&& :
- Use subtitution variables to supplement the following
- WHERE condition
- ORDER BY clause
- Column expressions
- Table names
- Entire SELECT statements
- Predefine variables by using DEFINE