VIEW: SYS.DBA_RSRC_CONSUMER_GROUPS

Source

View Text - Preformatted

select obj#,name,mgmt_method,mgmt_method,
       decode(internal_use,1,'YES','NO'),
       description,
       category,
       decode(status,'PENDING',status, NULL),
       decode(mandatory,1,'YES','NO')
from resource_consumer_group$

View Text - HTML Formatted

SELECT OBJ#
, NAME
, MGMT_METHOD
, MGMT_METHOD
, DECODE(INTERNAL_USE
, 1
, 'YES'
, 'NO')
, DESCRIPTION
, CATEGORY
, DECODE(STATUS
, 'PENDING'
, STATUS
, NULL)
, DECODE(MANDATORY
, 1
, 'YES'
, 'NO') FROM RESOURCE_CONSUMER_GROUP$