Re: SQL*PLUS simple quesion

You could always issue an initial select (say from DUAL) that would contain a list of all the columns (the "header record"). The next select would be your data. Turn the headings off if you are going to do this method though.

"Henning Eli Lang" <hlang_at_mail.htc.dk> wrote in message news:3A2E11DB.DAE9E2DB_at_mail.htc.dk...
> What we want to do is the following:
>
> We want our select statement to return the output in csv format i.e :
>
> field1,field2,field3
>
> The select statement we've tried was select field1 || ',' || field2 || ','
||
> field3, which works out ok except for one thing.
>
> The header returned was "field1||','||field2||',' etc..
>
> How do we make the heading look correkt i.e. field1,field2,field3
>
> another question: Is there a method to avoid the "N rows selected" , which
 is
> very annoying if you want to automatically process the output.
>
>
> --
> Venlig hilsen
>
> Henning Lang - Systemadministrator
>
> Erhvervsskolen Hamlet
> IT afdelingen
> Milnersvej 48
> 3400 Hillerød
>
> tlf: 48 29 01 23 / 24 86 99 04
> hlang_at_mail.htc.dk
Received on Mon Dec 11 2000 - 16:29:44 CET