批处理的问题！！

Question

就是在把建表和建过程，放在一个文件里呀，这个文件就是批处理文件
可是我不会在批处理文件里用sqlplus

Answer 1

把所有语句写在一个文件中如以：c:\a.sql
sql>@c:\a.sql;

Answer 2

一个ORACLE冷备份的批处理文件内容：
rem ************Oracle BackUP scrip*****************
rem ************************************************
rem ***************initialize***********************
del e:\backup\oradatabackup\Shutdowndb.sql
del e:\backup\oradatabackup\Startupdb.sql
del e:\backup\oradatabackup\coldbk.sql
del e:\backup\oradatabackup\coldbk.cmd
rem **********create Shutdowndb.sql
echo connect internal/oracle@ora >>e:\backup\oradatabackup\Shutdowndb.sql
echo shutdown immediate >>e:\backup\oradatabackup\Shutdowndb.sql
echo exit >>e:\backup\oradatabackup\Shutdowndb.sql
rem **********create Startup.sql
echo connect internal/oracle@ora >>e:\backup\oradatabackup\Startupdb.sql
echo startup >>e:\backup\oradatabackup\Startupdb.sql
echo >>e:\backup\oradatabackup\Startupdb.sql
echo exit >>e:\backup\oradatabackup\Startupdb.sql
rem ****Create coldbk.sql
echo set heading off; >> e:\backup\oradatabackup\coldbk.sql
echo set feedback off; >> e:\backup\oradatabackup\coldbk.sql
echo spool e:\backup\oradatabackup\coldbk.cmd >> e:\backup\oradatabackup\coldbk.sql echo select 'Copy '^|^| name ^|^|' e:\backup\oradatabackup\' from v$controlfile; >> e:\backup\oradatabackup\coldbk.sqlecho select 'Copy '^|^| name ^|^|' e:\backup\oradatabackup\' from v$datafile; >> e:\backup\oradatabackup\coldbk.sqlecho select 'Copy '^|^| member^|^|' e:\backup\oradatacackup\' from v$logfile; >> e:\backup\oradatabackup\coldbk.sqlecho spool off >> e:\backup\oradatabackup\coldbk.sqlecho exit >> e:\backup\oradatabackup\coldbk.sql
rem ***************************************************
rem ************Create coldbk.cmd
sqlplus internal/oracle@ora @e:\backup\oradatabackup\coldbk.sql
rem ************Add the backup of pfile,ifile,archivelog into coldbk.cmd***
echo Copy D:\oracle\ora81\database\initora.ora e:\backup\oradatabackup\ >>e:\backup\oradatabackup\coldbk.cmd
echo Copy D:\oracle\admin\ora\pfile\init.ora e:\backup\oradatabackup\ >>e:\backup\oradatabackup\coldbk.cmd
echo Copy D:\oracle\ora81\database\archive\*.* e:\backup\oradatabackup\ >>e:\backup\oradatabackup\coldbk.cmd
rem ****************************************************
rem ************ShutDown Datebase***********************
svrmgrl @e:\backup\oradatabackup\Shutdowndb.sql
rem ****************************************************
rem *********Run coldbk.cmd Then 
call e:\backup\oradatabackup\coldbk.cmd
rem ************StartUP datebase************************
svrmgrl @e:\backup\oradatabackup\Startupdb.sql
rem ****************************************************
rem **This is a simple oracle database backup script****
rem **It's only right to my database********************
rem **It need be changed for all the datebase of oracle*
rem ********2003-09-12 15:30****************************