sqlplus new line mystery
I have a script as follows, but the chr(10 does not work to insert a new line, instead a get a space, I have also tried exec dbms_output.new_line();, :
#!/bin/bash
source /home/oracle/.profile_dws_11202
cd /home/oracle
result=$(sqlplus -S ehcdba/all2fine << EOF
set head off
set feed off
set pagesize 999
set linesize 80
set time on
set timing on
set serveroutput on size 1000000
spool /home/oracle/stats.out
select '=================' from dual;
exec dbms_output.new_line();
select '=================' from dual;
select OWNER,TABLE_NAME,PARTITION_NAME,SUBPARTITION_NAME,NUM_ROWS,
LAST_ANALYZED from dba_TAB_STATISTICS where STALE_STATS='YES' and table_name = 'FACT_ORDER_CLINICAL' and owner = 'EHCDWH';