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