当前位置:首页 > 数据库 > 正文

pass value from shell to sql

2020-03-01 数据库

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

 

温馨提示: 本文由Jm博客推荐,转载请保留链接: https://www.jmwww.net/SQL/21697.html