Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How do I turn off output in SQL Plus?

How do I turn off output in SQL Plus?

From: JG <seniag75_at_SPAMSUX.yahoo.com>
Date: Wed, 18 Apr 2001 16:00:15 -0400
Message-ID: <mimD6.11185$u7.4230705@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:00:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US