批处理中执行SQL

test.bat
---------------------------------------------------------------------------
@echo off
echo\
echo\
echo\
echo ................................注意................................
echo\

sqlplus scott/password@test @test.sql
Pause

echo\

sqlplus scott/password@test @test.sql
Pause
exit;
---------------------------------------------------------------------------

test.sql
---------------------------------------------------------------------------
select * from scott.dept;
exit;
---------------------------------------------------------------------------

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17012874/viewspace-694199/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17012874/viewspace-694199/