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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Plus: How can I write each record to a separate file

Re: SQL*Plus: How can I write each record to a separate file

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 8 Sep 2006 11:56:26 -0700
Message-ID: <1157741785.948095.79360@i3g2000cwc.googlegroups.com>


Well, the more we know the more we can help... For example, you can easily following the @myscript.sql by a
!rm myscript.sql in Unix or Linux, or
!del myscript.sql on Windows, to delete your temporary script file

You can develop platform independent schema upgrade scripts that interact with environment files, and ... You didn't tell us the Oracle software release you are using, but as you may be aware, 10g has a more features that allow SQLPlus to interact with the OS.

hth Received on Fri Sep 08 2006 - 13:56:26 CDT

Original text of this message

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