VIEW: DVSYS.DV$REALM_OBJECT

Source

View Text - Preformatted

SELECT
      m.id#
    , m.realm_id#
    , d.name
    , u.name
    , m.object_name
    , m.object_type
    , m.version
    , m.created_by
    , m.create_date
    , m.updated_by
    , m.update_date
FROM dvsys.realm_object$ m, dvsys.dv$realm d, sys.user$ u
WHERE
    d.id# = m.realm_id# AND m.owner_uid# = u.user#
UNION
SELECT
      m.id#
    , m.realm_id#
    , d.name
    , '%'
    , m.object_name
    , m.object_type
    , m.version
    , m.created_by
    , m.create_date
    , m.updated_by
    , m.update_date
FROM dvsys.realm_object$ m, dvsys.dv$realm d
WHERE
    d.id# = m.realm_id# AND m.owner_uid# = 2147483636

View Text - HTML Formatted

SELECT M.ID#
, M.REALM_ID#
, D.NAME
, U.NAME
, M.OBJECT_NAME
, M.OBJECT_TYPE
, M.VERSION
, M.CREATED_BY
, M.CREATE_DATE
, M.UPDATED_BY
, M.UPDATE_DATE FROM DVSYS.REALM_OBJECT$ M
, DVSYS.DV$REALM D
, SYS.USER$ U WHERE D.ID# = M.REALM_ID#
AND M.OWNER_UID# = U.USER# UNION SELECT M.ID#
, M.REALM_ID#
, D.NAME
, '%'
, M.OBJECT_NAME
, M.OBJECT_TYPE
, M.VERSION
, M.CREATED_BY
, M.CREATE_DATE
, M.UPDATED_BY
, M.UPDATE_DATE FROM DVSYS.REALM_OBJECT$ M
, DVSYS.DV$REALM D WHERE D.ID# = M.REALM_ID#
AND M.OWNER_UID# = 2147483636