UNIX for Dummies Questions & Answers

#!/bin/ksh
echo `sqlplus -s <<EOF
     set feedback off
     set linesize 5000
     set pages 0
     set space 0
     set echo off
     set trimspool on
     set colsep '|'
     SELECT col1 , col2 , col3 FROM table_1;
     exit;
     EOF`

abc|def|123|awe|wed|12|qwe|qwe|45

abc|def|123
awe|wed|12
qwe|qwe|45

#!/bin/ksh
echo `sqlplus -s <<EOF
     set feedback off
     set linesize 5000
     set pages 0
     set space 0
     set echo off
     set trimspool on
     set colsep '|'
     RECSEPCHAR '~'
     RECSEP EACH 
     SELECT col1 , col2 , col3 FROM table_1;
     exit;
     EOF` |  tr -s '~' | tr '~' '\n'

echo "`sqlplus ...
...`" | ....

sqlplus -s <<EOF
     set feedback off
     set linesize 5000
     set pages 0
     set space 0
     set echo off
     set trimspool on
     set colsep '|'
     spool temp.csv     SELECT col1 , col2 , col3 FROM table_1;
     spool off
     exit;
    EOF
mv temp.csv file_1.txt