April 2000
Intermediate to advanced
94 pages
1h 52m
English
DEFINE
DEF[INE] [variable_name [= text]]
The DEFINE command allows you to create a user variable (or substitution variable) and to assign it a value. For example:
DEFINE company_name = "The Fictional Company"
You can also use DEFINE to list the value of one variable, or to list the values of all variables, as shown in these two examples:
DEFINE company_name DEFINE
Is the name of the variable you want to create. Issue the command with only a variable name, and SQL*Plus will display the current contents of that variable, if it exists.
Is the text you want to assign to the variable.