Re: help. Need Sql script to run nightly.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 11/8/00, 6:07:03 PM, jane ballard_at_my-deja.com wrote regarding help. Need Sql script to run nightly.:

> Hello all,
 

> Is there a way to have sqlplus execute a select statement to
> export the data set out on a nightly basis. The select condition
> changes daily however the columns selected does not.
 

> Is there a way to automate this? I'm on NT, oracle 8.0.5.
 

> Thanks in advance for any help. I've tried a few things. It
> didn't work.
 

> Jane

> Sent via Deja.com http://www.deja.com/
> Before you buy.

        Set up an AT command to invoke a sqlplus script stored in <drive>:\orant\bin Received on Wed Nov 08 2000 - 23:49:40 CST