.bat 批处理sql

今天研究了下怎么写bat，写出来后省了我不少构筑数据库环境的时间先是把一堆sql文件放在同一目录下，数量不限然后写以下2个bat文件ALL_FILE.bat
----------------------------------
SET FileName=%1
ECHO @%1 >>file.txt
ECHO .
ECHO %Next%
----------------------------------
GET_ALL_FILE.bat
----------------------------------
for %%i in (*.sql) do call ALL_FILE.bat %%i
pause
------------------------------------写完后执行GET_ALL_FILE.bat，生成file.txt
修改file.txt类型为sql，打开编辑file.sql末尾增加一句exit。再写个bat执行这个sql
EXE_SQL.bat
------------------------------------
sqlplus [username]/[password]@[db] @file.sql
pause

PS:sqlplus aaa01/[e-mail].16 @file.sql

========================================================================

sqlplus scott/tiger@zhpt @createUser.sql

imp dzjc/hldgajjzd file="dzjc.dmp" ignore=y fromuser=dzjc

imp drv_admin/oracleadmin file="drv_admin.dmp" ignore=y fromuser=drv_admin

imp veh_admin/oracleadmin file="veh_admin.dmp" ignore=y fromuser=veh_admin

pause
==============================================================================
--把sys和zlkj改为具有sysdba权限的用户名和密码(如sys用户)
conn sys/zlkj@dzjc_2005 as sysdba

--删除原DZJC用户
--DROP USER DZJC CASCADE
--/
--创建用户DZJC，密码为 hldgajjzd
CREATE USER DZJC IDENTIFIED BY "hldgajjzd"
/
--给DZJC用户DBA权限
GRANT DBA TO DZJC
/
--用DZJC用户连接数据库
CONN DZJC/hldgajjzd@zhpt

commit;

INSERT INTO "DZJC"."DZJC_YHMC"(userid,pwd,username,glbm) VALUES ('0','admin888','admin888','admin');

commit;

--创建用户DRV_DZJC，密码为 oracleadmin
CREATE USER DRV_DZJC IDENTIFIED BY "oracleadmin"
/
--给DRV_DZJC用户DBA权限
GRANT DBA TO DRV_DZJC
/
--用DRV_DZJC用户连接数据库
CONN DRV_DZJC/oracleadmin@zhpt
/

commit;

--创建用户VEH_DZJC，密码为 oracleadmin
CREATE USER VEH_DZJC IDENTIFIED BY "oracleadmin"
/
--给VEH_DZJC用户DBA权限
GRANT DBA TO VEH_DZJC
/
--用VEH_DZJC用户连接数据库
CONN VEH_DZJC/oracleadmin@zhpt
/

commit;

exit