高手帮忙把这段转换成bat

Ann725 Ann725 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
#!/usr/bin/ksh

# Input Parameters
# 1) T2_SYS_PWD
# 2) T2_TNSNAME
# 3) T2_SCHEMA_NAME
# 4) T2_SCHEMA_PWD
# 5) AR_SCHEMA_NAME
# 6) AR_SCHEMA_PWD

T2_SYS_PWD=$1
T2_TNSNAME=$2
T2_SCHEMA_NAME=$3
T2_SCHEMA_PWD=$4
AR_SCHEMA_NAME=$5
AR_SCHEMA_PWD=$6

usage()
{
echo ""
echo "USAGE:"
echo 'Full_Build_AR.sh T2_SYS_PWD T2_TNSNAME T2_SCHEMA_NAME T2_SCHEMA_PWD AR_SCHEMA_NAME AR_SCHEMA_PWD'
echo ' '
}

if (( $# < 6 ))
then
echo "Not enough parameters passed in!"
usage
exit 1
fi

start_time=`date`
echo ------* THE compile script BEGIN $start_time *------

echo Executing AR_USERSCHEMA.sql
sqlplus -L -S SYS/$T2_SYS_PWD@$T2_TNSNAME as SYSDBA @AR_USERSCHEMA.sql $AR_SCHEMA_NAME $AR_SCHEMA_PWD $T2_SCHEMA_NAME
echo .

echo Executing RPS_AR_FILE_AUTHORING.sql
sqlplus -L -S $AR_SCHEMA_NAME/$AR_SCHEMA_PWD@$T2_TNSNAME @execute_and_exit.sql RPS_AR_FILE_AUTHORING.sql
echo .

echo Executing GRANT_AUTHORING.sql
sqlplus -L -S $AR_SCHEMA_NAME/$AR_SCHEMA_PWD@$T2_TNSNAME @GRANT_AUTHORING.sql $T2_SCHEMA_NAME $AR_SCHEMA_NAME
echo .

echo Executing Recompile_AR_Processing.sql
sqlplus -L -S $T2_SCHEMA_NAME/$T2_SCHEMA_PWD@$T2_TNSNAME @Recompile_AR_Processing.sql
echo .

echo Executing RPS_AR_FILE_FAR001.sql
sqlplus -L -S $AR_SCHEMA_NAME/$AR_SCHEMA_PWD@$T2_TNSNAME @execute_and_exit.sql RPS_AR_FILE_FAR001.sql
echo .

echo Executing RPS_AR_FILE_SAF001.sql
sqlplus -L -S $AR_SCHEMA_NAME/$AR_SCHEMA_PWD@$T2_TNSNAME @execute_and_exit.sql RPS_AR_FILE_SAF001.sql
echo .

echo Executing RPS_AR_FILE_SWC500.sql
sqlplus -L -S $AR_SCHEMA_NAME/$AR_SCHEMA_PWD@$T2_TNSNAME @execute_and_exit.sql RPS_AR_FILE_SWC500.sql
echo .

echo Executing RPS_AR_FILE_TXU3003.sql
sqlplus -L -S $AR_SCHEMA_NAME/$AR_SCHEMA_PWD@$T2_TNSNAME @execute_and_exit.sql RPS_AR_FILE_TXU3003.sql
echo .

echo Executing RPS_AR_FILE_UNI002.sql
sqlplus -L -S $AR_SCHEMA_NAME/$AR_SCHEMA_PWD@$T2_TNSNAME @execute_and_exit.sql RPS_AR_FILE_UNI002.sql
echo .

echo Executing RPS_AR_FILE_WFM151.sql
sqlplus -L -S $AR_SCHEMA_NAME/$AR_SCHEMA_PWD@$T2_TNSNAME @execute_and_exit.sql RPS_AR_FILE_WFM151.sql
echo .

end_time=`date`
echo ------* THE compile package END $end_time *--------

exit
...全文
评论 5
收藏 已收藏
分享
返回顶部
Ann725
Windows Server 6,873 成员 177,926 内容