#!/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.
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