Execute SQL from batch file

Question

I'm new to batch files scripting.

All I want is creating a batch file that calling SQL file and store results in text file .

Can anyone help me, your help is highly appreciated,

This is the first time I need to create such files.

Answer 1

using a batch file:

save and run this:

@echo off
sqlplus -s -l user/pass@yourdb @yoursql.sql>your_log.log

p.s. be sure to have the last line of your sql script as exit; or the batch file will hang.

Answer 2

sqlcmd -S sqlservername -i yoursqlfile.sql -U username -P password -o outputfile.txt