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