| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: sql o/p to Excel
Ravindra,
Yep its possible to transform your o/p from spool into excel, but you will need to format your data before extraction.
you can do this by select fieldname||chr(32)||fieldname from blah;
where chr(32) represents the space character, which will help you to print in a different column in excel.
hope this helps.
raja
-- On Thu, 21 Jun 2001 18:10:20 Ravindra Basavaraja wrote:Received on Thu Jun 21 2001 - 21:02:56 CDT
>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).
>
Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: viraj999_at_lycos.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).
 |
 |