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/
Received on Fri Jun 17 2005 - 17:37:05 CDT