How to create formulas in an SQL statement
VactirioMay 25 2007 — edited May 30 2007Hello,
I am trying to create a formula in an sql statement without creating a external function.
Here is my example :
select (x + y) as a,
(x + y) + 2
from dual
As you can see the formula “(X + Y)” is repeated.
I would be glad to write a select statement like that :
select (x + y) as a,
a + 2
from dual
any ideas?
Thanks