取消定义:
set DEFINE OFF
SQL> set define off
SQL> select * from dual where 1 = #
SP2-0552: Bind variable "NUM" not declared.
SQL>
还原变量定义:
set DEFINE ON
SQL> select * from dual where 1 = #
Enter value for num: 1
old 1: select * from dual where 1 = &num
new 1: select * from dual where 1 = 1
D
-
X