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
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
|
|
|