Re: function returning object type and print the attributes

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Mon, 18 Jul 2016 16:32:20 +0300
Message-ID: <CAOVevU5X62wU7fDwmjN2eACUnpg8gLvKG0BNwh1r88UiKUVLxA_at_mail.gmail.com>



> If we use rownum (which forces inlinve view materialization) it is
another extra call, so 1 + 2.
Inline view should calculated value once and after that oracle should use calculated value on other plan steps. You should see it in the PROJECTION note of the execution plan.
Could you show full test? I've checked it on 12.1.0.2 and function calls once.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 18 2016 - 15:32:20 CEST

Original text of this message