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
