VIEW: SYS.DBA_CDB_RSRC_PLANS

Source

View Text - Preformatted

select obj#,name,
       description,
       decode(status,'PENDING',status, NULL),
       decode(mandatory,1,'YES','NO')
from cdb_resource_plan$
where sys_context('userenv', 'con_id') = 1
order by status

View Text - HTML Formatted

SELECT OBJ#
, NAME
, DESCRIPTION
, DECODE(STATUS
, 'PENDING'
, STATUS
, NULL)
, DECODE(MANDATORY
, 1
, 'YES'
, 'NO') FROM CDB_RESOURCE_PLAN$ WHERE SYS_CONTEXT('USERENV'
, 'CON_ID') = 1 ORDER BY STATUS