After my researches about the methods to connect sqlplus and run an SQL command in a shell script, i wanted to share the results with you.

Here are two methods for this purpose:


DB_NAME=$($ORACLE_HOME/bin/sqlplus -s $username/$password << EOF!
select name from v$database;
echo $DB_NAME > name.log

LOCAL_SQL='select name from v$database;'
DB_NAME=`echo $LOCAL_SQL | $ORACLE_HOME/bin/sqlplus -s $username/$password`
echo $DB_NAME > name.log

Both two methods successfully bring SQL command's output to a file. Difference seems to be just syntax. But i'll be pleased if anyone has any experience on this and share with me.

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -