VIEW: SYS.DBA_RSRC_CATEGORIES

Source

View Text - Preformatted

select name,
       description,
       decode(status,'PENDING',status, NULL),
       decode(mandatory,1,'YES','NO')
from resource_category$

View Text - HTML Formatted

SELECT NAME
, DESCRIPTION
, DECODE(STATUS
, 'PENDING'
, STATUS
, NULL)
, DECODE(MANDATORY
, 1
, 'YES'
, 'NO') FROM RESOURCE_CATEGORY$