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.
--
Rene Nyffenegger
http://www.adp-gmbh.ch/
Received on Fri Jun 17 2005 - 01:17:43 CDT
