SQLPLUS - Verify

Card Puncher Data Processing


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.
-- You can suppress this listing by setting the SET command variable VERIFY to OFF.

Discover More
Card Puncher Data Processing
SQL Plus - Substitution Variables

You can define variables, called substitution variables, for repeated use in a single script. Note that you can also define substitution variables to use in titles and to save your keystrokes (by defining...
Card Puncher Data Processing
SQL Plus - System Variable (Configuration)

System Variables Description APPI[NFO]{ON | OFF | text} Sets automatic registering of scripts through the DBMS_APPLICATION_INFO package. arraysize Sets the number of rows, called a batch, that SQLPlus...

Share this page:
Follow us:
Task Runner