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

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...