UNDEFINE

Purpose

Deletes one or more user variables that you defined either explicitly (with the DEFINE command) or implicitly (with an argument to the START command).

Syntax

UNDEF[INE] variable ...

Terms and Clauses

Refer to the following for a description of the term or clause:

variable

Represents the name of the user variable you wish to delete. One or more user variables may be deleted in the same command.

Examples

To undefine a user variable named POS, enter

SQL> UNDEFINE POS

To undefine two user variables named MYVAR1 and MYVAR2, enter

SQL> UNDEFINE MYVAR1 MYVAR2