DBA Data[Home] [Help]

VIEW: DVSYS.KU$_DV_ISR_VIEW

Source

View Text - Preformatted

select '0','0'
    from sys.dual
   where (sys_context('USERENV','CURRENT_USERID') = 1279990
          or exists (select 1
                       from sys.session_roles
                      where role='DV_OWNER'))
     and exists (select 1
                   from dvsys.realm_object$ objects_in_realm
                  where objects_in_realm.REALM_ID# > 5000)
View Text - HTML Formatted

SELECT '0'
, '0'
FROM SYS.DUAL
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 1279990 OR EXISTS (SELECT 1
FROM SYS.SESSION_ROLES
WHERE ROLE='DV_OWNER'))
AND EXISTS (SELECT 1
FROM DVSYS.REALM_OBJECT$ OBJECTS_IN_REALM
WHERE OBJECTS_IN_REALM.REALM_ID# > 5000)