Computed field in Select clause

Hi Zac, Thank you for the posting "Computed field in Select clause". A feature enhancement request has been submitted , but no estimate on when it might become available. Regards, Bhawana

Bhawana, Thank you. Would you change the status to "Under Consideration" Zac.

Hi Zac, Do you know that you can subqueries to obtain the same, don't you? such as select a1, a1*10 from (select 1+1 as a1 from dual); Does make sense? It should not be extra penalty cost for the subquery, but agree is not as clean as your example but it should work. Btw, all the feature request are always under consideration and are reviewed in a triage meetings, some of them get done earlier just based on priority, other features and difficulty. But we always review feature request. Hope this helps, nice to "talk" with you again. Eugenia

Eugenia, I agree that in most cases, a sub query or a with clause will be sufficient for simple examples as I posted. But a "Computed" field will be handy especially when the computation is very complex or needs to be done on each row of the resultset. Zac.