OraFAQ Forum: Unix » storing multiple set of data into same excel file

Home » Infrastructure » Unix » storing multiple set of data into same excel file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

storing multiple set of data into same excel file [message #391308]

Wed, 11 March 2009 13:17

shrinika
Messages: 306
Registered: April 2008

Senior Member

Hello -

Is it possible to store two different set of data in the same excel file. One set of data should go into one tab.
Another set of data should go to another tab in the same excel.. Please let me know.

Here is the shell script i am using..

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

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 temp;

exit;
EOF

Now i wanted to run the another query and load the data into the same csv file(xyz.csv)... Is it possible?

Report message to a moderator

Re: storing multiple set of data into same excel file [message #391310 is a reply to message #391308]

Wed, 11 March 2009 13:27

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Not a in CSV file.

Regards
Michel

Report message to a moderator

Re: storing multiple set of data into same excel file [message #391313 is a reply to message #391308]

Wed, 11 March 2009 13:58

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Generate separate spooled outputs and join them later.
A simple unix job.

Kaapi:ora magvivek$ cat f1
ename,sal,job
ename,sal,job
ename,sal,job
Kaapi:ora magvivek$ cat f2
dname,loc
dname,loc
dname,loc
dname,loc
dname,loc
Kaapi:ora magvivek$ pr -m -t -s f1 f2 
ename,sal,job	dname,loc
ename,sal,job	dname,loc
ename,sal,job	dname,loc
	dname,loc
	dname,loc
Kaapi:ora magvivek$ pr -m -t -s f1 f2 > f3.xls

Is this the output you are looking into?
/forum/fa/5884/0/

Attachment: Picture 1.png
(Size: 54.12KB, Downloaded 3115 times)

[Updated on: Wed, 11 March 2009 14:04]

Report message to a moderator

Re: storing multiple set of data into same excel file [message #391315 is a reply to message #391313]

Wed, 11 March 2009 14:41

shrinika
Messages: 306
Registered: April 2008

Senior Member

Thank you...

Report message to a moderator

Previous Topic:	using dos2unix on multiple files (merged)
Next Topic:	Call Shell script from SQL?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 10:34:19 CST 2024