Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Report Writer 3.0

Re: Report Writer 3.0

From: John Chiu <johnymc_at_netscape.net>
Date: Tue, 7 Dec 1999 06:18:27 -0500
Message-ID: <82iq8p$k3v$1@news2.tor.accglobal.net>


I always use ',' as field seperator. the sql statement looks like:

select field1 || ',' || field2 ||',' || ......from table;

in excel, you open the document and specify the ',' is the seperator and it always works.

HTH John Chiu

Kasi <kskasi_at_netscape.net> wrote in message news:384CA9AA.4CC602E7_at_netscape.net...
> Hello everone
>
> I'm trying to send output from one of my reports on to an excel file. It
> send's okay. But the problem is, I have 4 columns in my report and all
> of them appear on the same cell in the excel sheet. In my application I
> can't use csv file's either. Any suggesstions...
>
> Thanx in advance...kasi
>
Received on Tue Dec 07 1999 - 05:18:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US