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

Loading xml file data to oracle table using python

Sample xml file (test.xml): <?xml version="1.0"?> <data>     <customer name="Ravi" >     ...