define

Syntax

define name [= value]

Description

Defines a string substitution alias.

If no value is provided, ttIsql displays the current definition for the specified name.

You must set define on to enable command substitution.

undefine name undefines a string substitution alias.

Examples

You can change the special character used for string-substitution aliases from & to another character $.

set define on
set define $

Command> Set define on; 
Command> define q = 'myvalue';
Command> select '&q' from dual;
< myvalue >
1 row found.

define2var defines the value and make it a variable that you can use as a parameter variable.

define2var myalias mybindvar 
Command> define2var a1 arr[2];

var2define it takes the value of a named variable and then define it.

var2define mybindvar myalias
Command> var2define arr[2] alias2;