Message-Id: <10676.121741@fatcity.com> From: Chuck Hamilton Date: Fri, 10 Nov 2000 08:56:19 -0800 (PST) Subject: Appending SQLPLUS output on NT --0-1649760492-973875379=:11589 Content-Type: text/plain; charset=us-ascii Use a double > to redirect sqlplus's output. sqlplus -s < script.sql >> outputfile script.sql ======= user/password select..... exit ARUN K C wrote: Hi, Can somebody please let me know how I can append a file on NT platfomr thro sqlplus so that it doesnt overwrite the file. Cause I am running some monitoring scripts i want all the results to be in the same file. Thanks in advance _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C INET: arun_k_c@hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --------------------------------- Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. All with one Wallet. --0-1649760492-973875379=:11589 Content-Type: text/html; charset=us-ascii

Use a double > to redirect sqlplus's output.

sqlplus -s < script.sql >> outputfile

script.sql
=======
user/password
select.....
exit

  ARUN K C <arun_k_c@hotmail.com> wrote:

Hi,
Can somebody please let me know how I can append a file on NT platfomr thro
sqlplus so that it doesnt overwrite the file.
Cause I am running some monitoring scripts i want all the results to be in
the same file.
Thanks in advance

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ARUN K C
INET: arun_k_c@hotmail.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, sen! d an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).


Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. All with one Wallet.