SQL*Plus 系统变量之59 - VER[IFY]

VER[IFY] {OFF|ON}

控制SQL*Plus在替换置换变量之前或之后时是否列出SQL语句或PL/SQL命令的文本。

SQL> define v=scott.dept

SQL> set verify on

SQL> select * from &v;

原值    1: select * from &v      ---VERIFY=ON，所以将显示替换前后的SQL语句

新值    1: select * from scott.dept

 

    DEPTNO DNAME          LOC

---------- -------------- -------------

        10 ACCOUNTING     NEW YORK

        20 RESEARCH       DALLAS

        30 SALES          CHICAGO

        40 OPERATIONS     BOSTON

SQL> set verify off

SQL> select * from &v;          ---VERIFY=OFF，所以不会显示替换前后的SQL语句

 

    DEPTNO DNAME          LOC

---------- -------------- -------------

        10 ACCOUNTING     NEW YORK

        20 RESEARCH       DALLAS

        30 SALES          CHICAGO

        40 OPERATIONS     BOSTON