Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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). Received on Thu Jun 21 2001 - 20:32:15 CDT