I need to write an SQL command (Oraclee 11gR2) like this:
SELECT F1, MYFUNCT(F2) as F2_updated
FROM MYTAB m
WHERE m.F3 = MYFUNCT(F2) ;
-- WHERE m.F3 = F2_updated does not seem to work
How can I reuse the value "F2_updated" I already obtained in the SELECT clause when I am writing the WHERE clause?
I made the example simple but I need to use "F2_updated" multiple times inside the WHERE clause. How do I simplify this?