RE: Using SQL*Plus

>Subject: Using SQL*Plus
>From: kkha_at_hkuxa.hku.hk (Ha Kong Kuen), The University of Hong Kong
>Date: Tue, 11 May 1993 07:34:10 GMT
>
> I want to write some sql*plus scripts to extract
>pure ASCII data files and need to pass parameters to the scripts.
>The output file displays the old and new values at the beginning
>of the ASCII files. How do I suppress these two lines.

I have trouble remembering which one it is, too. I end up looking in the User's Guide Index under SET to find the SET OPTIONS and then narrow down the choices to a few and begin experimenting. For this one I tried:

SET ECHO OFF
SET SCAN OFF
SET TERMOUT OFF
SET SHOW OFF until this one worked:

SET VERIFY OFF In the "SQL*Plus User's Guide and Reference", 5142-V3.0 0991, p.6-62:

    VER[IFY] {OFF|ON} Controls whether SQL*Plus lists the text of a

                      command before and after SQL*Plus replaces
                      substitution variables with values. ON lists the
                      text; OFF suppresses the listing.

========================================================================
                                            chicago ,--------+  detroit
Tom Harleman                                        |        |
INOUG Committee Member                              |Indiana |
Paradigm Consulting, Inc.                 st.       | Oracle |
11080 Willowmere Drive                    louis     |  Users |
Indianapolis, IN  46280                             |   Group|
USA                                                 |        |
                                                    |      _,+cincinnati
INTERNET:   72072.2122_at_compuserve.com               /   _,'
Compuserve: 72072,2122                             /_,-'louisville
                                                   `
========================================================================