用bat添加一条oracle,Bat文件往oracle中批量插入数据

1，Bat文件:

set NLS_LANG=AMERICAN_AMERICA.AL32UTF8

echo build "conn.sql"

echo =========================================

sqlplus /nolog @"conn.sql"

2,conn.sql

spool log.log

set verify off

@"define_variable.properties"

prompt

prompt build schema @"1.sql"

prompt =========================================

prompt

connect &&v_username/&&[email protected]&&v_tnsname

@"xxxxxxxxx.orasql"

exit;

3,定义用户名和密码define_variable.properties

define v_tnsname=ora11g define v_username=scott define v_pwd=tiger