set ver on/off

最新推荐文章于 2021-04-05 13:14:32 发布

weixin_30361753

最新推荐文章于 2021-04-05 13:14:32 发布

阅读量145

点赞数

原文链接：http://www.cnblogs.com/abclife/p/5404557.html

版权

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

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>

转载于:https://www.cnblogs.com/abclife/p/5404557.html