set ver on/off

 

set   verify(或ver)   on/off可以设置是否显示替代变量被替代前后的语句

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

SQL> set verify on SQL> select &num from dual; Enter value for num: 1 old   1: select &num from dual new   1: select 1 from dual            1 ----------          1   SQL> set verify off SQL> select &num from dual; Enter value for num: 1            1 ----------          1   SQL>