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

Perfect order of ODI export and import

  Smart Export / Import is the recommended way to achieve such a migration. This is the easiest way to make sure all the dependencies are ta...