SQL Language (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center