You
don't need to get rid of the commas. A CSV file will automatically be read into
excel and all the commas will become a breakpoint for new columns. Or
alternatively a spooled output can be read into excel, it will open the format
wizard to specify the breakpoints for columns
But
the question is what if the comma is within the value of a column? In that case
excel will create one more column. How to overcome that in a spooled CSV
file?
Naveen
By the way, would you use replace to get rid of the commas withiin fields
so that Excel reads it properly?
dgoulet@vicr.com wrote:
Bob,
You
can create a CSV file from SQL*Plus with the following
statement:
select
||','||
from
where <......................>;
Dick
Goulet
____________________Reply
Separator____________________
Author: Bob Robert
Date: 9/20/2002 12:33 PM
All,
Is it
possible to create Oracle reports into Excel
format ?
Is it possible
to spool Oracle tables into Excel
format?
Thanks in
Advance
Bob
__________________________________________________
Do
you Yahoo!?
New DSL Internet Access from SBC &
Yahoo!
http://sbc.yahoo.com
--
Please see the official ORACLE-L
FAQ: http://www.orafaq.com
--
Author: Bob Robert
INET:
mssql_2002@yahoo.com
Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego! ! , California -- Mailing list and web
hosting
services
---------------------------------------------------------------------
To
REMOVE yourself from this mailing list, send an E-Mail message
to:
ListGuru@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:
dgoulet@vicr.com
Fat City Network Services -- 858-538-5051
http://www.fatcity.com
San Diego, California -- Mailing list and web
hosting
services
---------------------------------------------------------------------
To
REMOVE yourself from this mailing list, send an E-Mail message
to:
ListGuru@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).
Do you Yahoo!?
New DSL Internet
Access from SBC & Yahoo!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
INET: naveen_nahata_at_mindtree.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Sat Sep 21 2002 - 08:08:20 CDT
