--檢視SHELL指令碼
[oracle@localhost script]$ cat test.sh
REPORT_USER=ADMGEMALTO
REPORT_PASS=ADMGEMALTO
DB_LINK_NAME=OTA4G
#echo $REPORT_USER
sqlplus -silent "${REPORT_USER}/${REPORT_PASS}@${DB_LINK_NAME}" << EOF
DEFINE VAR_1=2
DEFINE VAR_2=DUAL
SELECT SYSDATE FROM DUAL;
@01.sql
exit 0
EOF

--檢視SQL檔案
[oracle@localhost script]$ cat 01.sql
select &&VAR_1 from &&VAR_2;

--呼叫SHELL指令碼
[oracle@localhost script]$ sh test.sh

SYSDATE
-------------------
2017-02-17 11:11:01

old   1: select &&VAR_1 from &&VAR_2
new   1: select 2 from DUAL

   2
----------
   2

Oracle SQLPLUS中DEFINE在SHELL中的呼叫

相關文章