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:
>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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
