批量执行文件夹下的所有SQL文件

@echo off
set logName = sqllog.log
del all.sql
echo spool %logName% >> all.sql
for /f %%a in ('dir *.sql /s /b /a-d') do (
  echo %%a| findstr all.sql >nul && echo @%%a || echo @%%a >> all.sql
)
echo spool off >> all.sql

sqlplus USERNAME/PASSWORD@主机IP:1521/orcl @all.sql >> sqllog.log

pause