Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> help. Need Sql script to run nightly.

help. Need Sql script to run nightly.

From: <jane_ballard_at_my-deja.com>
Date: Wed, 08 Nov 2000 23:07:03 GMT
Message-ID: <8ucmah$g4m$1@nnrp1.deja.com> 






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.
Received on Wed Nov 08 2000 - 17:07:03 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US