I want to use the value of a complex function several times within a query. I had thought I could do something like:

SELECT (...complex function...) as x,
log(x) as log_x
FROM somewhere
WHERE x > 3
AND x <= 10
OR ....(more uses of x)

But this doesn't work.

What do you suggest?

Thanks in advance!
-David

You can use the function in the from clause to return the value and access it in the query multiple times.

SELECT x, log(x) as log_x
FROM somewhere, (select f_cmplx as x from dual) b
WHERE x > 3
AND x <= 10
OR ....(more uses of x)
/

That worked! Thanks!