Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How do I turn off output in SQL Plus?
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