VIEW: SYS._ALL_REPCOLUMN

Source

View Text - Preformatted

select r.sname, r.oname, r.type, r.lcname, r.id, r.pos, r.flag, r.ctype,
  r.length, r.precision#, r.scale, r.null$, r.charsetid, r.charsetform,
  r.cname, r.toid, r.ctype_owner, r.ctype_name, r.version#, r.hashcode,
  r.top, r.property, r.clength
from all_tab_columns tc, system.repcat$_repcolumn r
where r.sname = tc.owner
  and r.oname = tc.table_name
  and ((NVL(r.top, r.cname) = tc.column_name) OR
       (r.top IS NULL AND r.cname = 'SYS_NC_OID$' AND
        -- sOID column
        utl_raw.bit_and(utl_raw.substr(r.property, 1, 1), '10') = '10'))
union
select
  r.sname, r.oname, r.type, r.lcname, r.id, r.pos, r.flag, r.ctype,
  r.length, r.precision#, r.scale, r.null$, r.charsetid, r.charsetform,
  r.cname, r.toid, r.ctype_owner, r.ctype_name, r.version#, r.hashcode,
  r.top, r.property, r.clength
from "_ALL_REPL_NESTED_TABLE_NAMES" nt, system.repcat$_repcolumn r
where r.sname = nt.owner
  and r.oname = nt.table_name

View Text - HTML Formatted

SELECT R.SNAME
, R.ONAME
, R.TYPE
, R.LCNAME
, R.ID
, R.POS
, R.FLAG
, R.CTYPE
, R.LENGTH
, R.PRECISION#
, R.SCALE
, R.NULL$
, R.CHARSETID
, R.CHARSETFORM
, R.CNAME
, R.TOID
, R.CTYPE_OWNER
, R.CTYPE_NAME
, R.VERSION#
, R.HASHCODE
, R.TOP
, R.PROPERTY
, R.CLENGTH FROM ALL_TAB_COLUMNS TC
, SYSTEM.REPCAT$_REPCOLUMN R WHERE R.SNAME = TC.OWNER
AND R.ONAME = TC.TABLE_NAME
AND ((NVL(R.TOP
, R.CNAME) = TC.COLUMN_NAME) OR (R.TOP IS NULL
AND R.CNAME = 'SYS_NC_OID$' AND -- SOID COLUMN UTL_RAW.BIT_AND(UTL_RAW.SUBSTR(R.PROPERTY
, 1
, 1)
, '10') = '10')) UNION SELECT R.SNAME
, R.ONAME
, R.TYPE
, R.LCNAME
, R.ID
, R.POS
, R.FLAG
, R.CTYPE
, R.LENGTH
, R.PRECISION#
, R.SCALE
, R.NULL$
, R.CHARSETID
, R.CHARSETFORM
, R.CNAME
, R.TOID
, R.CTYPE_OWNER
, R.CTYPE_NAME
, R.VERSION#
, R.HASHCODE
, R.TOP
, R.PROPERTY
, R.CLENGTH FROM "_ALL_REPL_NESTED_TABLE_NAMES" NT
, SYSTEM.REPCAT$_REPCOLUMN R WHERE R.SNAME = NT.OWNER
AND R.ONAME = NT.TABLE_NAME