DBA Editions

➜ Back to Library
XLSExcel example XMLXML import file

Description

Categories
Enginatics, R12 only
Repository
GitHub
Database editions, their type and status

SQL 8 lines

select 
de.edition_name,
de.parent_edition_name,
ad_zd.get_edition_type(de.edition_name) type,
de.usable,
xxen_util.yes(decode(de.edition_name,sys_context('userenv','current_edition_name'),'Y')) "Current"
from
dba_editions de