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