Re: Oracle to excel at server side

Hi,

Create a CSV file and read into Excel. Check the "Generate CSV" thread started by the user "Titi". It was answered by Sybrand Bakker and is as follows:

Regards,
Kyle

On Sat, 23 Mar 2002 11:06:05 +0100, "Titi" <thierry.constant2_at_wanadoo.fr> wrote:

>Hi,
>
>simple SQL question for you:
>how can I generate a csv file from a table in oracle ?
>
>something like:
>set head off
>set feed off
>select col1||';',col2||';'... from table_name ;
>
>the columns are in several lines , not one line
>I have problem with col format I think
>
>How can I do that ??
>
>Thanks
>
>
>

First of all you either need to rigorously use
col||';'||col2||';'||col3||';'
etc, so basically return one expression
or use
set colsep ';'
and
select col1,col2,col3 etc.
The linesize can be changed by using the set linesize <n> command.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

"Ada" <ada106_at_yahoo.com> wrote in message news:6bd047ec.0203242010.b58ed20_at_posting.google.com...
> Hi,
>
> I want to place Oracle data in an excel worksheet through programming
> at Solaris (server side). Has anyone a solution for this?
>
> Thanks for your help.
>
> Ada
Received on Sun Mar 24 2002 - 22:39:17 CST