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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Create SQL Batch File

Re: Create SQL Batch File

From: Billy O'Connor <billyoc_at_linuxfromscratch.org>
Date: Wed, 08 Jan 2003 22:14:49 GMT
Message-ID: <81adibe1gx.fsf@dps10.oconnoronline.net>


"Mohamed Badr" <MohamedBadr75_at_hotmail.com> writes:

> Hello,
> I want to make a linux or dos batch file to run a SQL Command
> i.e. SQLPLUS.exe scott/tiger SQL_COMMAND
> so how can I write this batch file like that.

I'm not sure I understand you, if you have a small file, "test1.sql", containing the following:

select * from emp
/
quit

You can run this with 'sqlplus scott/tiger @test1.sql'.

-- 
Billy O'Connor
Editor, Beyond Linux From Scratch   http://beyond.linuxfromscratch.org
"Free software never simply picks up its marbles and goes home."
      - Jonathan Corbet, LWN
Received on Wed Jan 08 2003 - 16:14:49 CST

Original text of this message

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