pass value from shell to sql 

echo 'please enter new userid need create'
read new_usr
echo 'please enter userid to model'
read model_usr
echo 'please enter SOEID for password'
read new_pwd

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

 

posted @ 2019-10-19 19:36  kakaisgood  阅读(117)  评论(0)  编辑  收藏  举报