Reg editioning views

[Satish]

Dear erman,

Little confusion with editioning views. Do we have 2 editioning views  one in run edition and other in patch edition?
OR
We have only one editioning view that we can see it from both the edition?

Thank you

[satish]

Thanks for the notes erman.
from this demo http://ermanarslan.blogspot.in/2015/07/ebs-122-and-ebr-lets-make-demo.html,is the below editioning view(olderman) will exist in both the editions?

ERMAN_EDITION ( PATCH/OLD EDITION)

SQL> select * from erman;

DUMMY      DUMMY2
---------- --------------------------------------------------
X

SQL> select * from olderman;

DUMMY
--------------------------------------------------

select status from dba_objects where object_name='ERMANP1';

STATUS
-------
VALID


ORA$BASE EDITION (RUN EDITION)

SQL>  select * from erman;

DUMMY      DUMMY2
---------- --------------------------------------------------
X

SQL> select * from olderman;

DUMMY
----------
X

select status from dba_objects where object_name='ERMANP1';

[ErmanArslansOracleBlog]

In that example we have 2.
If you read the blog post cerefully, you will see it

What we have in that blog post are;


IN BASE EDITION:

CREATE OR REPLACE EDITIONING VIEW OLDERMAN AS
SELECT DUMMY
FROM ERMAN

IN ERMAN EDITION:

CREATE OR REPLACE EDITIONING VIEW OLDERMAN AS
SELECT DUMMY2 as dummy
FROM ERMAN

[satish]

Thats an awesome explanation.Its very useful to in understanding the internals in an easy way