how to pass variable from shell script to sqlplus

script

sqlplus ${ORA_USR}/${ORA_PASS}@${ORA_DB} @${PARM}/TEST $new_usr $model_usr $new_pwd

parm of sql

define V_USERID = '&1';
define V_MODEL  = '&2';
define V_PASSWD = '&3';

INSERT INTO XX(
 

exit;
原文地址:https://www.cnblogs.com/kakaisgood/p/11820258.html