Re: change column "labels" using select command

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 18 Oct 1999 06:49:57 +0200
Message-ID: <940222213.14971.0.pluto.d4ee154e@news.demon.nl>

select a namex

       , b namey
       , c namez

from xtable;

Hth

--
Sybrand Bakker, Oracle DBA
Manny <mpatel_at_news.fhlb.com> wrote in message news:7udva4$s54$1_at_tilde.csc.ti.com...
> How do I change column Name while doing select command for report.
>
> for example:
>
> select a, b, c from xtable;
>
> output:
>
> A B C
> ===== ====== =======
> AAA BBB CCC
>
> I need following output:
>
> Namex Namey Namez
> ===== ====== =======
> AAA BBB CCC
>
> thanks!
>
> Manny
Received on Sun Oct 17 1999 - 23:49:57 CDT