How do I create a batch file for SQLPlus?

Question

I need to create a batch file i.e. batch.bat

...

When we execute this file:

file1.sql

contains user-specific create and insert scripts.

I have file.sql

, but I need to know, how do I create a batch file to perform this function?

+1

Gokul May 19 '09 at 5:37 am

1 answer

andri · Answer 1 · 2009-05-19T05:47:42+0000

Small test script (stored in a file named test.sql

):

select 1 from dual;

exit;

... and execute it:

sqlplus user/password @test.sql