Re: Using computed col in same select

A copy of this was sent to birzerc_at_meiller.de (Christian Birzer) (if that email address didn't require changing) On Mon, 06 Sep 1999 08:37:56 GMT, you wrote:

>Hi!
>
>I'm trying to find a way to use a computed value in the same select
>agein, without subselects, like this:
>
>select a * 2 "b", "b" * 2 "c" from table;
>
>instead of
>
>select "b"*2 "c" from
> (select a*2 "b" from table)
>
>Anybody knows how to do this???
>

the way to do it is the way you don't want to do it.

other then creating a static view "select a*2 b from table" and selecting from it -- the above is the way to do it.

>Thanks in advance!
>
>Regards
>
>Christian Birzer
>

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Sep 06 1999 - 07:58:09 CDT