Useful shortcuts for vi editor

Showing posts with label shell script. Show all posts
Showing posts with label shell script. Show all posts

Tuesday, 21 October 2014

How to run sql query in shell script?

Please add these codes into your .sh file then you can run .sh file

e.g. 
ssh -q -T oracle@192.168.2.2 << EOF
sqlplus / as sysdba << EOFSQL
drop user ALPER_DB_USER cascade;
exit;
EOFSQL
EOF