Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Create SQL Batch File
"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, LWNReceived on Wed Jan 08 2003 - 16:14:49 CST
![]() |
![]() |