INSTALLATION DOCUMENTS BY RAVI

Saturday, April 15, 2017

Shell Script for Updating Table in a Oracle Database

#!/bin/bash
export ORACLE_HOME=/app/oracle/product/11.2.0/dbhome1/
export SID=orcl
export PATH=/app/oracle/product/11.2.0/dbhome1/bin
sqlplus -s scott/tiger@orcl <<EOF
UPDATE EMP_ID='10';
commit;
/
EOF

Copy the above code to a file and save it as .sh file and by running this file the script will update the table.

No comments:

Post a Comment

  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...