Options

Computed field in Select clause

Zacharia_MathewZacharia_Mathew
in General Discussion
Ability to use a calculated field in a query select 1+1 as a1, a1 *10 as a2 from dual; Refer Case 00017808 / JIRA VER-27155. SQL Server and some other DBs support this. The use of a with clause and a subquery will suffice in most cases but this feature will be beneficial too. Zac.

Comments

  • Options
    BhawanaBhawana
    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
  • Options
    Zacharia_Mathew_1Zacharia_Mathew_1
    Bhawana, Thank you. Would you change the status to "Under Consideration" Zac.
  • Options
    [Deleted User][Deleted User] ✭
    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
  • Options
    Zacharia_Mathew_1Zacharia_Mathew_1
    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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...