How to run SQL in shell script
Maybe it's too late for answering but, there's a working code:
sqlplus -s "/ as sysdba" << EOF SET HEADING OFF SET FEEDBACK OFF SET LINESIZE 3800 SET TRIMSPOOL ON SET TERMOUT OFF SET SPACE 0 SET PAGESIZE 0 select (select instance_name from v\$instance) as DB_NAME, file_name from dba_data_files order by 2;