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: Newbie:Spool file

Re: Newbie:Spool file

From: William Robertson <william.robertson_at_bigfoot.com>
Date: 18 Jun 2005 03:10:11 -0700
Message-ID: <1119089411.243252.185580@g14g2000cwa.googlegroups.com>


Generic Account 1209 wrote:
> Rene Nyffenegger <rene.nyffenegger_at_gmx.ch> wrote:
> > On 2005-06-16, Dmitry E. Loginov <lde_at_mpsb.ru> wrote:
> >>
> >> "Generic Account 1209" <masc1209_at_rohan.sdsu.edu> wrote in message
> >> news:d8qnj4$ivg$1_at_gondor.sdsu.edu...
> >>>
> >>> Hello Everyone,
> >>> I am learning SqlPlus and I wonder if there's a way
> >>> to append the some of my SQL practice into the same
> >>> file?
> >>> I mean, I would like to something like the following
> >>>
> >>> SQL>spool prac.txt
> >>> SQL>select * from empbb02;
> >>> .....
> >>> SQL>spool off
> >>> SQL>do something else
> >>> .....
> >>> SQL>spool prac.txt
> >>> SQL>alter table empbb02....
> >>> .....
> >>> SQL>spool off
> >>> ....
> >>>
> >>> I would like to capture only some of my practice into the
> >>> same file.
> >>> Is there a way to do it?
> >>
> >>
> >> Unfortunately you can't append spool to a existing file, nevertheless you
> >> can spool your output to set of files (prac1.txt, prac2.txt, etc) and
> >> concatenate ones later by the OS coman (f.e. copy) using HOST command in
> >> SQLPlus.

>

> > It's possible to append spool output to an existing file with 10g.
>

> Our school only has Oracle 9i :-(
> But I am still interested in how to do it in Oracle 10g though?
> Is it automatically append to the spool file by default?
> Thank you
>
>

> > --
> > Rene Nyffenegger
> > http://www.adp-gmbh.ch/

You are learning SQL*Plus without loking at the manual?

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b12170/ch13.htm#sthref2969 Received on Sat Jun 18 2005 - 05:10:11 CDT

Original text of this message

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