DBA Data[Home] [Help]

VIEW: SYS.DBA_REPCOLUMN

Source

View Text - Preformatted

select sname, oname, type, cname, id, nvl(pos, lpos), compare_old_on_delete,
          compare_old_on_update, send_old_on_delete, send_old_on_update,
          ctype, ctype_toid, ctype_owner, ctype_hashcode, ctype_mod,
          data_length, data_precision, data_scale, nullable,
          character_set_name, top, char_length, char_used
from repcat_repcolumn_base
View Text - HTML Formatted

SELECT SNAME
, ONAME
, TYPE
, CNAME
, ID
, NVL(POS
, LPOS)
, COMPARE_OLD_ON_DELETE
, COMPARE_OLD_ON_UPDATE
, SEND_OLD_ON_DELETE
, SEND_OLD_ON_UPDATE
, CTYPE
, CTYPE_TOID
, CTYPE_OWNER
, CTYPE_HASHCODE
, CTYPE_MOD
, DATA_LENGTH
, DATA_PRECISION
, DATA_SCALE
, NULLABLE
, CHARACTER_SET_NAME
, TOP
, CHAR_LENGTH
, CHAR_USED FROM REPCAT_REPCOLUMN_BASE