Home » SQL & PL/SQL » Client Tools » SQLPlus - How to hide the results during a SQL File exection
SQLPlus - How to hide the results during a SQL File exection [message #247534] Tue, 26 June 2007 04:50 Go to next message
michael.mazuk
Messages: 14
Registered: June 2007
Junior Member
Hello !

I'm loading data in Oracle Database with SQLPlus. The problem is that i'm loading a big file and I would like to hide the screen results and just see them in a file.

With the spool command, I obtain my results in the file. But how can I hide the screen results ("1 row created") ?

Thank you for you help !

SQL> spool test.log

SQL> @toto.sql

1 row created

1 row created

....
Re: SQLPlus - How to hide the results during a SQL File exection [message #247536 is a reply to message #247534] Tue, 26 June 2007 04:56 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
SET TERMOUT OFF.

MHE
Previous Topic: Page Break on a field
Next Topic: execute a procedure returning ref cursor in toad
Goto Forum:
  


Current Time: Fri Dec 09 13:38:09 CST 2016

Total time taken to generate the page: 0.07992 seconds