execution view
Hi,
I've a very simple view:
CREATE OR REPLACE FORCE VIEW xxxxx
( KOL1, KOL2 )
BEQUEATH DEFINER
AS
SELECT samecolumn, samecolumn FROM tablexx;
So the view references to the samecolumn twice. And my question is:
will Oracle fetch the column once on twice?
I tried to trace the execution with ALTER SESSION SET EVENTS '10046 trace name context forever, level 12'; and ALTER SESSION SET EVENTS '10053 trace name context forever, level 12';
and some other events but I don't see it. I assume Oracle will fetch the value once but want to know exactly how Oracle executes this.
regards,
Ivan