Re: How do I turn off output in SQL Plus?

set feedback off
prompt Creating Tables
...create tables here...
prompt Creating Views
...create views here

"JG" <seniag75_at_SPAMSUX.yahoo.com> wrote in message news:mimD6.11185$u7.4230705_at_e3500-chi1.usenetserver.com...
> Hello all,
>
> I hope this is a simple question. I am creating a setup script in Oracle
> that creates a tablespace, user, tables, packages, etc. The first part of
> the script accepts some parameters and such. After this is done, the
 script
> commences with creating all of the objects.
>
> In SQL*Plus, the screen is flooded with Table Created, Procedure Created,
> etc. messages as the objects are created. Is there a way to turn off this
> output to the screen and enter my own comments like...
>
> "Creating tables....."
> "Creating views...."
>
> so things aren't so cluttered?
>
> Any code snippets would be much appreciated. Thanks in advance.
>
> Jamie
>
>
>
>
Received on Wed Apr 18 2001 - 15:11:56 CDT