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 -> Re: running SQL scripts in UNIX

Re: running SQL scripts in UNIX

From: James Dickson <James.Dickson_at_mail.esrin.esa.it>
Date: Mon, 08 Jun 1998 10:21:06 +0200
Message-ID: <357B9EF2.55B5@mail.esrin.esa.it>


bmolish wrote:
>
> If I create an SQL script, do I have to be in svrmgrl or sqlplus to invoke it?

From your unix script include the line:   svrmgrl command=@/path/myscript.sql

where myscript.sql is like:
  connect user/pass
  SQL statements
  exit

James
--
james_at_valhall.esrin.esa.it.nospam Received on Mon Jun 08 1998 - 03:21:06 CDT

Original text of this message

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