Re: name of column

From: Oré <abarrau_at_ifrance.com>
Date: Mon, 19 Aug 2002 16:24:56 +0200
Message-ID: <ajqv2l$ukj$1@s1.read.news.oleane.net>

Thanks,

but how do you do it where you used a request as SELECT * FROM counts; ???

I can't use this solution !

Can you help me again ?

thanks...

Aurélien

"Richard Foote" <Richard.Foote_at_bigpond.com> a écrit dans le message news: 3D60F568.9ECDAB26_at_bigpond.com...
> Hi There
>
> SELECT nomChamp "nonChamp" FROM counts;
>
> or
>
> SELECT nonChamp AS "nonChamp" FROM counts;
>
> or
>
> col nonChamp heading 'nonChamp'
> SELECT nonChamp FROM counts;
>
> Cheers
>
> Richard
>
>
> "Or" " wrote:
> >
> > I could see with oracle, if this type of requete is made:
> > SELECT nomChamp FROM counts;
> > oracle turn over the value with the name of column: NOMCHAMP and
not
> > nomChamp.
> >
> > It was the same where i used an AS
> >
> > But my requetes I recupere directly the name of the fields or the as...
> >
> > I would like use nomChamp and not NOMCHAMP,
> > someone can help me ?????
> >
> > thanks
> >
> > Aurelien
Received on Mon Aug 19 2002 - 09:24:56 CDT