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

Home -> Community -> Usenet -> c.d.o.tools -> Automating SQL calls

Automating SQL calls

From: Tim Mavers <webview_at_hotmail.com>
Date: 11 May 2001 13:03:07 -0500
Message-ID: <3afc28ca$0$16467$45beb828@newscene.com>

I am wondering what is the best way to automate SQL calls in Oracle 8i? I need to run a bunch of statements automatically several times a week.

Is the best way to use sqlplus and specify a .SQL file (with the GET command)?

I am coming from a MS SQL Server environment (and am used to DTS), so I am not sure about Oracle basics.

Thanks! Received on Fri May 11 2001 - 13:03:07 CDT

Original text of this message

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