VERIFY
VER[IFY] ON | OFF 

Controls whether SQL*Plus lists the text of a modified line of a SQL or PL/SQL block before and after SQL*Plus replaces substitution variables with values.

Keywords

ON

Specifies that the line containing modified text be displayed. This is the default.

OFF

Specifies that the line containing modified text not be displayed. Note that this option affects display only; the substitution will still occur.

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.