Shell Programming and Scripting

${ORACLE_HOME}/bin/sqlplus -s ${ORA_USER}/${ORA_PASSW}@${ORACLE_SID} << EOF > ${FTP_TO}/T_i1_exportdocs_b.xls

set pages 0
set echo off
set ver off
set feed off
set linesize 600
SELECT
'Delivery #'||','||'REGION'||','||'Proforma Invoice'||','||'SONUM'||','||'Export Docs print date'||','||'Export Docs print time'||','||'SLD2NAME'||','||'Frei
ght Fwdr (name)'||','||'Shipto Ctry'||','||'Shipping Point'||','||'Extract Date' from dual;

select
"Delivery #"||','||
REGION||','||
"Proforma Invoice"||','||
SONUM||','||
"Export Docs print date"||','||
"Export Docs print time"||','||
SLD2NAME||','||
"Freight Fwdr (name)"||','||
"Shipto Ctry"||','||
"Shipping Point"||','||
"Extract Date"
FROM t_i1_exportdocs;

exit;
EOF

awk '{sub(/$/,"\r");print}' < T_i1_exportdocs_b.xls > /odsimp/supply_chain/"Global Order Mgmt"/"US Exports"/EXPORT_LOG_SQL/yy.xls

Delivery #,REGION,Proforma Invoice,SONUM,Export Docs print date,Export Docs print time,SLD2NAME,Freight Fwdr (name),Shipto Ctry,Shipping Point,Extract Date
0099578218,CALA,2900005302,0011331536,03/09/2009,12:31:40,AVAYA Communication,CON-WAY CENTRAL EXPRESS,MX,CF3N,03/10/2009
0099579232,CALA,2900005303,0011331542,03/09/2009,12:32:14,AVAYA Communication,CON-WAY CENTRAL EXPRESS,MX,CF3N,03/10/2009