How to run sql*plus and its command in Windows as batch job?

Hi, All,

  In unix, we can put following commands in a file and run that file. For example:

$ORACLE_HOME/bin/sqlplus /nolog << EOF
connect test/test
alter sesion set sql_trace=true
select count(*) from product_temp p, invoice_temp i where p.invpsid=i.invoiceid;
disconnect
exit
EOF What's the corresponding format on windows?

Your input is precious, Received on Wed Mar 19 2003 - 21:17:28 CST