Linux/Unix shell 参数传递到SQL脚本

2、在SQL提示符下传递参数

robin@SZDB:~/dba_scripts/custom/awr> more tmp2.sh

#!/bin/bash

# ----------------------------------------------

#  Set environment here

#  Author : Robinson Cheng

# ----------------------------------------------

if [ -f ~/.bash_profile ]; then

. ~/.bash_profile

fi

if [ -z "${1}" ] || [ -z "${2}" ] || [ -z "${3}" ] ;then

echo "Usage: "

echo "      `basename $0` <ORACLE_SID> <begin_dat> <end_date>"

read -p "please input begin ORACLE_SID:" ORACLE_SID

read -p "please input begin date and time(e.g. yyyymmddhh24):" begin_date

read -p "please input end date and time(e.g. yyyymmddhh24):" end_date

else

ORACLE_SID=${1}

begin_date=${2}

end_date=${3}

fi

export ORACLE_SID begin_date end_date

#Method 2: pass the parameter in SQL prompt. Using the same method with method 1

sqlplus -S " / as sysdba" <<EOF

@/users/robin/dba_scripts/custom/awr/tmp.sql $begin_date $end_date

exit;

EOF

exit

（编辑：云计算网_泰州站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!