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.

Articles Related

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