Define command

SQL*XL
home

Syntax:
Version 1: def[ine] variable=text;
Version 2: def[ine]variable;
Version 3: def[ine];

Description:
Version 1:
Defines a substitution variable. If the variable does not exist it will be created. If there is already a variable with that name, the value will be set.

Version 2:
Displays the definition (value and data type) of the substitution variable in a message box.

Version 3:
Shows the parameters dialog. You can configure variables in the parameters dialog.

Examples:
define employee = Jones;
define my_variable= 'Hello World';
define a=1;
define my_variable;

< P> define;

See also: