[Home] [Help]
VIEW: SYS.USER_REPGENOBJECTS
Source
View Text - Preformatted
select r.sname, r.oname, r.type, r.base_sname, r.base_oname, r.base_type,
r.package_prefix, r.procedure_prefix, r.distributed, r.reason
from repcat_generated r, user_users u
where r.base_sname = u.username
View Text - HTML Formatted
SELECT R.SNAME
, R.ONAME
, R.TYPE
, R.BASE_SNAME
, R.BASE_ONAME
, R.BASE_TYPE
,
R.PACKAGE_PREFIX
, R.PROCEDURE_PREFIX
, R.DISTRIBUTED
, R.REASON
FROM REPCAT_GENERATED R
, USER_USERS U
WHERE R.BASE_SNAME = U.USERNAME