SQLPLUS - Verify

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.

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

Powered by ComboStrap