Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: sql o/p to Excel
Hi Ravindra,
Bein in the same situation like you a few months ago I manage to figure out 2 solutions at your problem:
Regards,
Pierre
-----Original Message-----
From: ravindra [SMTP:ravindra_at_sentica.com]
Sent: Friday, June 22, 2001 4:10 AM
To: ORACLE-L Cc: ravindra Subject: sql o/p to Excel
I have a sql script to generate a dialy report like this.
01-JUN-200107 8 4 17 18 11 *********** ------------- MAXIMUM No. 11 TOTAL 15 04-JUN-200108 9 2 10 11 1 11 12 2 12 13 3 13 14 16 14 15 4 17 18 2 18 19 2 *********** ------------- MAXIMUM No. 16 TOTAL 32
I want to present this output in excel so that I can draw graphs.I am not
able to open the file
in excel in alligned format ie each column must appear in different columns
in excel.How can I do that.
Is that possible?
Thanks
Ravindra
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ravindra Basavaraja
INET: ravindra_at_sentica.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: pierre.olaru_at_citicorp.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jun 22 2001 - 04:09:27 CDT
![]() |
![]() |