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