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;

 

上一篇:重启Oracle 服务


下一篇:oracle sqlplus配置