how to create batch file for sqlplus?

Question

hi, i need to crate a batch file.(batch.bat) When we execte this bathch.bat file, 1)it will open sqlplus 2)it will call file1.sql file.

file1.sql contains the creation and insertion scripts for a particular user.

i am having file.sql file... so, what i need to know is.. how to Creat a batch file to perform this functions..??

Thanks in advance...

Answer 1

A little test script (stored in file named test.sql):

select 1 from dual;

exit;

... and to execute it:

sqlplus user/password @test.sql