Re: Running an SQL File

From: Dennis Richter <dennis_richter_at_csi.com>
Date: Fri, 25 Feb 2000 20:29:52 -0500
Message-ID: <897acf$rvc$1@ssauraaa-i-1.production.compuserve.com>

sqlplus with the -s option (silent mode) should do the trick.

For example: sqlplus -s userid/password @script.sql

If you do not want to pass userid and password on the command line, then include the /NOLOG parameter and issue the CONNECT from within the script file.

Sally Madeira <softsense_at_home.com> wrote in message news:38B6FCED.31458D6_at_home.com...
> Hello,
>
> I have sveral *.sql files that I need to run during a process that I am
> writing in visual basic. I am using ADO and have not found anything
> that is useful. These sql scripts are not short. One script creates 20
> temporary tables! Is there a command line argument that I could kick
> off from VB that could run the scripts.
>
> Thanks
> Sally
Received on Fri Feb 25 2000 - 19:29:52 CST

Re: Running an SQL File - help