Shell Programming

Get Oracle Query Result from Shell

If you want to get data from Oracle using shell, you can use this script


$SQLPLUS -s $ORACLE_USER/$ORACLE_PASSWD@$ORACLE_SID << EOF >> $FILE
@$SQL_SCRIPT
exit
EOF

In order to avoid feedback and title heading, you may add


set heading off
set feedback off

on your $SQL_SCRIPT

Advertisements

Discussion

No comments yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Archives

Twitter Updates

Error: Please make sure the Twitter account is public.

%d bloggers like this: