SQLPLUS - Verify

> Procedural Languages > (SQL Plus|SqlCl) (Oracle Database Console)

1 - About

After you enter a value at the prompt, SQL*Plus lists the text of a SQL statement or PL/SQL command containing the substitution variable twice:

  • once before substituting the value you enter
  • and once after substitution.

You can change this mode with the help of the VERIFY parameters.

Advertising

3 - Command

--Lists each line of the script before and after substitution.
SET VERIFY ON
-- You can suppress this listing by setting the SET command variable VERIFY to OFF.
SET VERIFY OFF
lang/sqlplus/verify.txt · Last modified: 2017/05/09 16:51 by gerardnico