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