Re: name of column

Hi Again,

You haven't used all the solutions !

The last one will solve your problem.

col nonChamp heading 'nonChamp'
SELECT * FROM counts;

Cheers

Richard

"Oré" " wrote:
>
> 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 - 19:25:28 CDT