pass value from shell to sql

时间:2022-06-12 04:17:20

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