set verify on/off
来源:互联网 发布:华讯网络应届生待遇 编辑:程序博客网 时间:2024/04/28 10:28
The SET VERIFY command is used to turn on and off the display of command lines that have had substitutions performed.
ON turns the display of the changed lines on. This is the default value.
OFF turns the display of changed lines off.
VER added with version 9i.
当在sqlplus中运行的sql语句中有替代变量(以&或&&打头)的时候,
set verify(或ver) on/off可以设置是否显示替代变量被替代前后的语句。
如:
SQL> set ver on;
SQL> select * from dual where 1=&var;
Enter value for var: 1
old 1: select * from dual where 1=&var
new 1: select * from dual where 1=1
DU
--
X
而如果设为off,则显示如下:
SQL> set ver off;
SQL> select * from dual where 1=&var;
Enter value for var: 1
DU
--
X
使用以&和&&开头的替代变量的前提是set define on;(不过这是缺省状态)。
- set verify on/off
- SET NOCOUNT { ON | OFF }
- SET NOCOUNT ON | OFF
- SET XACT_ABORT { ON | OFF }
- Set NoCount ON/OFF
- SET QUOTED_IDENTIFIER ON|OFF
- SET NOCOUNT { ON | OFF }
- set verify off的作用
- set echo on/off,set term on/off,set feedback off,set heading off的问题
- set echo on/off,set term on/off,set feedback off,set heading off命令
- set echo on/off,set term on/off,set feedback off,set heading off命令
- set ansi_nulls [on/off] 与 set quoted_identifier [on/off]
- SET QUOTED_IDENTIFIER {ON|OFF}和SET ANSI_NULLS {ON | OFF}
- 关于SET QUOTED_IDENTIFIER {ON|OFF}的问题
- 关于SET QUOTED_IDENTIFIER {ON|OFF}的问题
- 关于SET QUOTED_IDENTIFIER {ON|OFF}的问题
- SET QUOTED IDENTIFIER ON|OFF用法
- 关于SET QUOTED_IDENTIFIER {ON|OFF}的问题
- 一个生成迷宫的算法
- 消息映射机制的简单实现
- RedHat AS5 Liux配置LVS集群
- Howto: Deploy VC2008 apps without installing vcredist_x86.exe
- C#操作Word
- set verify on/off
- NetBeans 6.5 + Mysql 配置 EJB 3.0 ( 一 )
- C技巧:请特别注意VC字符集设置
- DOS清空垃圾文件
- 当朋友都远离你而去......
- 一个代替linux的fetion的软件,用起来挺方便的,而已可以在控制下就能使用。
- C# 堆栈与堆(托管堆)
- QQ空间非主流经典个性日志:五不能娶,五不能嫁
- Kxml2解析xml例子