DBA Data[Home] [Help]

VIEW: SYS.KU$_RMGR_CONSUMER_VIEW

Source

View Text - Preformatted

select '1','0',
        r.obj#,
        (select value(o) from  sys.ku$_schemaobj_view o where
                o.obj_num=r.obj#),
        r.mgmt_method,
        r.description,
        r.status, r.mandatory
  from resource_consumer_group$ r
View Text - HTML Formatted

SELECT '1'
, '0'
, R.OBJ#
, (SELECT VALUE(O)
FROM SYS.KU$_SCHEMAOBJ_VIEW O WHERE O.OBJ_NUM=R.OBJ#)
, R.MGMT_METHOD
, R.DESCRIPTION
, R.STATUS
, R.MANDATORY
FROM RESOURCE_CONSUMER_GROUP$ R