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

From: <zrwcvhsosoik001_at_sneakemail.com>
Date: 8 Sep 2006 12:24:16 -0700
Message-ID: <1157743456.709249.126900@m79g2000cwm.googlegroups.com>

G Quesnel wrote:
> 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.

Well, that was my point about being platform independent. The script needs to run on Linux, unix and windows. Database versions 9.2 and 10g.

Can you please elaborate on the following:
> You can develop platform independent schema upgrade scripts that
> interact with environment files, and ...
I don't quite understand what you mean, but it sounds like it could be interesting. Received on Fri Sep 08 2006 - 14:24:16 CDT