VIEW: SYS.ALL_EDITIONS

Source

View Text - Preformatted

select o.name, po.name, decode(bitand(e.flags,1),1,'NO','YES')
from sys.obj$ o, sys.edition$ e, sys.obj$ po
where o.obj# = e.obj#
  and po.obj# (+)= e.p_obj#

View Text - HTML Formatted

SELECT O.NAME
, PO.NAME
, DECODE(BITAND(E.FLAGS
, 1)
, 1
, 'NO'
, 'YES') FROM SYS.OBJ$ O
, SYS.EDITION$ E
, SYS.OBJ$ PO WHERE O.OBJ# = E.OBJ#
AND PO.OBJ# (+)= E.P_OBJ#