Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Running an SQL File - help
put exit after the script ends
so a script might read
create table test(test1 varchar2(20)
/
exit
HTH
"Sally Madeira" <softsense_at_home.com> wrote in message
news:38B8702E.8BEACDF1_at_home.com...
> I did the following and this worked great. Since I am running this from
> a visual basic app I need to make sure the sqlplus window closes after
> the script is complete. What would I need to do to terminate
> (disconnect and exit) the process of the sqlplus.
>
>
>
> Dennis Richter wrote:
> >
> > 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 Tue Feb 29 2000 - 03:26:54 CST