Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I turn off output in SQL Plus?
Thanks, Chuck. That's just what I was looking for.
I appreciate it.
Jamie
"Chuck Hamilton" <chuck_hamilton_at_hotmail.com> wrote in message
news:9bksg9$9sif4$1_at_ID-85580.news.dfncis.de...
> 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:40:12 CDT