DBA Data[Home] [Help]

VIEW: SYS.USER_REPCATLOG

Source

View Text - Preformatted

select r.id, r.source, r.userid, r.timestamp, r.role, r.master, r.sname,
  r.request, r.oname, r.type, r.status, r.message, r.errnum, r.gname
from repcat_repcatlog r, user_users u
where r.sname = u.username or r.userid = u.username
View Text - HTML Formatted

SELECT R.ID
, R.SOURCE
, R.USERID
, R.TIMESTAMP
, R.ROLE
, R.MASTER
, R.SNAME
, R.REQUEST
, R.ONAME
, R.TYPE
, R.STATUS
, R.MESSAGE
, R.ERRNUM
, R.GNAME FROM REPCAT_REPCATLOG R
, USER_USERS U WHERE R.SNAME = U.USERNAME OR R.USERID = U.USERNAME