Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Executing a SQL from svrmgr from command line
create shell script like the following
svrmgr30.exe @e:\sample.sql
in the sql file login and put sql statements
connect scot/tiger
select table_name from user_tables;
Praveen Mohanan wrote in message
<942861734.224930_at_sj-nntpcache-2.cisco.com>...
>TO DBA GURUS,
>
>
> I wanted to execute one few commands from the command line & exit at the
>end. For eg
>
>1. invoke srvmgr
>2. connect internal
>3. run a SQL script
>4. exit
>
>How can i write this in a shell script, so that if i call the shell, it
will
>run all these command & come back to the prompt.
>
>
>Regards
>
>
Received on Wed Nov 17 1999 - 12:42:10 CST