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. |
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