Scripting

在 shell 腳本中執行 SQLFILE 之前將空行設置為 ON

  • May 5, 2016
echo exit | sqlplus username/password@host_ip:port/Service_name @SQLFILENAME

我想在執行set sqlbl on之前執行,SQLFILENAME並且還希望在執行SQLFILENAME之後應該退出 sqlplus

$SQLPLUS -S username/password@ip:port/servicename<< EOF
SQL-STATEMENTS
set sqlbl on 
commit
EOF

引用自:https://dba.stackexchange.com/questions/122522