VIEW: SYS.USER_REPCOLUMN

Source

View Text - Preformatted

select
 r.sname, r.oname, r.type, r.cname, r.id, r.pos, r.compare_old_on_delete,
 r.compare_old_on_update, r.send_old_on_delete, r.send_old_on_update,
 r.ctype, r.ctype_toid, r.ctype_owner, r.ctype_hashcode,
 r.ctype_mod, r.data_length, r.data_precision, r.data_scale, r.nullable,
 r.character_set_name, r.top, r.char_length, r.char_used
from user_tab_columns tc, sys.dba_repcolumn r, sys.user$ u
where r.sname = u.name
  and u.user# = userenv('SCHEMAID')
  and r.oname = tc.table_name
  and ((r.top IS NOT NULL AND r.top = tc.column_name) OR
       (r.top IS NULL AND r.cname = tc.column_name))
union
select
 r.sname, r.oname, r.type, r.cname, r.id, r.pos, r.compare_old_on_delete,
 r.compare_old_on_update, r.send_old_on_delete, r.send_old_on_update,
 r.ctype, r.ctype_toid, r.ctype_owner, r.ctype_hashcode,
 r.ctype_mod, r.data_length, r.data_precision, r.data_scale, r.nullable,
 r.character_set_name, r.top, r.char_length, r.char_used
from "_USER_REPL_NESTED_TABLE_NAMES" nt, sys.dba_repcolumn r, sys.user$ u
where r.sname = u.name
  and u.user# = userenv('SCHEMAID')
  and r.oname = nt.table_name

View Text - HTML Formatted

SELECT R.SNAME
, R.ONAME
, R.TYPE
, R.CNAME
, R.ID
, R.POS
, R.COMPARE_OLD_ON_DELETE
, R.COMPARE_OLD_ON_UPDATE
, R.SEND_OLD_ON_DELETE
, R.SEND_OLD_ON_UPDATE
, R.CTYPE
, R.CTYPE_TOID
, R.CTYPE_OWNER
, R.CTYPE_HASHCODE
, R.CTYPE_MOD
, R.DATA_LENGTH
, R.DATA_PRECISION
, R.DATA_SCALE
, R.NULLABLE
, R.CHARACTER_SET_NAME
, R.TOP
, R.CHAR_LENGTH
, R.CHAR_USED FROM USER_TAB_COLUMNS TC
, SYS.DBA_REPCOLUMN R
, SYS.USER$ U WHERE R.SNAME = U.NAME
AND U.USER# = USERENV('SCHEMAID')
AND R.ONAME = TC.TABLE_NAME
AND ((R.TOP IS NOT NULL
AND R.TOP = TC.COLUMN_NAME) OR (R.TOP IS NULL
AND R.CNAME = TC.COLUMN_NAME)) UNION SELECT R.SNAME
, R.ONAME
, R.TYPE
, R.CNAME
, R.ID
, R.POS
, R.COMPARE_OLD_ON_DELETE
, R.COMPARE_OLD_ON_UPDATE
, R.SEND_OLD_ON_DELETE
, R.SEND_OLD_ON_UPDATE
, R.CTYPE
, R.CTYPE_TOID
, R.CTYPE_OWNER
, R.CTYPE_HASHCODE
, R.CTYPE_MOD
, R.DATA_LENGTH
, R.DATA_PRECISION
, R.DATA_SCALE
, R.NULLABLE
, R.CHARACTER_SET_NAME
, R.TOP
, R.CHAR_LENGTH
, R.CHAR_USED FROM "_USER_REPL_NESTED_TABLE_NAMES" NT
, SYS.DBA_REPCOLUMN R
, SYS.USER$ U WHERE R.SNAME = U.NAME
AND U.USER# = USERENV('SCHEMAID')
AND R.ONAME = NT.TABLE_NAME