Re: help. Need Sql script to run nightly.

From: David Fitzjarrell <oratune_at_aol.com>
Date: Wed, 08 Nov 2000 23:17:41 GMT
Message-ID: <8ucmud$gls$1@nnrp1.deja.com>

In our last gripping episode jane_ballard_at_my-deja.com wrote:
> 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.
>

How drastically does the WHERE clause change?

> 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.
>

Most likely there is, but without knowing a bit more information it will be difficult to assist.

--
David Fitzjarrell
Oracle Certified DBA


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

Received on Wed Nov 08 2000 - 17:17:41 CST