Re: 7.3.4 on NT: exporting text w/an automated script

Thanks. I just learned that SQL*Plus can be run entirely from the command line in batch (without invoking the GUI), which is what had been my real stumbling block.

On Mon, 15 May 2000 13:17:10 GMT, Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:

>You can use Win AT just like you plan on using for your FTP process.
>Write a batch file that calls sqlplus. That script should also invoke
>the .sql script you want to run.
>
>HTH,
>Brian
>
>Ken Ho wrote:
>>
>> On Sat, 13 May 2000 03:39:40 GMT, "Greg Kainz" <gregkainz_at_home.com>
>> wrote:
>>
>> >check out http://www.evergreen-database.com in Tim's shared scripts area.
>> >I think
>> >he still has Gary Dodge's "Unload Table" script there.
>> >Greg
>> >Ken Ho <hoke_at_gse.harvard.edu> wrote in message
>> >news:391c2b98.8203536_at_news.harvard.edu...
>> >> What can people recommend for exporting straightforward text data from
>> >> a table in Oracle 7.3.4 on Win NT 4 in an automated script? Is there
>> >> a command-line way to invoke SQL*PLUS or SQL Worksheet to do so? My
>> >> goal is to take that text and FTP it elsewhere in a script using the
>> >> WINAT facility.
>>
>> Thanks. Unload_fixed.sql is still at that site. What do people use
>> to *invoke* SQL scripts in a batch file from the DOS prompt?
>
>--
>========================================
>Brian Peasland
>Raytheons Systems at
> USGS EROS Data Center
>These opinions are my own and do not
>necessarily reflect the opinions of my
>company!
>========================================
Received on Mon May 15 2000 - 00:00:00 CDT