Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: name of column
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 - 08:40:56 CDT