Re: SQL*PLUS simple quesion

Michel Cadot wrote:
>
> Answer embedded.
>
> --
> Have a nice day
> Michel
>
> Henning Eli Lang <hlang_at_mail.htc.dk> a écrit dans le message : 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
>
> select field1 || ',' || field2 || ',' || field3 as "field1,field2,field3"
> from ...

Thanks very much for the solution, which leaves me with only one small problem:

When I use the solution the .. as "......" apparently is limited to 30 characters. Is there a way to overcome this limit ?

>
> >
> > another question: Is there a method to avoid the "N rows selected" , which is
> > very annoying if you want to automatically process the output.
>
> set feedback off
>
> >
> >
> > --
> > 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
 

-- 
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