Name

DEFINE

Synopsis

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

Parameters

variable_name

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.

text

Is the text you want to assign to the variable.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset