Re: function returning object type and print the attributes
- From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
- To: Ls Cheng <exriscer@xxxxxxxxx>
- Date: Mon, 18 Jul 2016 16:32:20 +0300
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.
Other related posts:
