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;

 

posted @ 2019-11-08 14:53  kakaisgood  阅读(141)  评论(0)    收藏  举报