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.
--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