VIEW: SYS.DBA_PUBLISHED_COLUMNS

Source

View Text - Preformatted

SELECT
   s.change_set_name, s.change_table_schema, s.change_table_name, s.obj#,
   s.source_schema_name, s.source_table_name, c.column_name,
   c.data_type, c.data_length, c.data_precision, c.data_scale, c.nullable
  FROM sys.cdc_change_tables$ s, dba_tables t, dba_tab_columns c
  WHERE s.change_table_schema=t.owner AND
        s.change_table_name=t.table_name AND
        c.owner=s.change_table_schema AND
        c.table_name=s.change_table_name AND
        c.column_name NOT IN ('OPERATION$','CSCN$','DDLDESC$','DDLPDOBJN$',
           'DDLOPER$','RSID$','SOURCE_COLMAP$','TARGET_COLMAP$',
           'COMMIT_TIMESTAMP$','TIMESTAMP$','USERNAME$','ROW_ID$',
           'XIDUSN$','XIDSLT$','XIDSEQ$','SYS_NC_OID$')

View Text - HTML Formatted

SELECT S.CHANGE_SET_NAME
, S.CHANGE_TABLE_SCHEMA
, S.CHANGE_TABLE_NAME
, S.OBJ#
, S.SOURCE_SCHEMA_NAME
, S.SOURCE_TABLE_NAME
, C.COLUMN_NAME
, C.DATA_TYPE
, C.DATA_LENGTH
, C.DATA_PRECISION
, C.DATA_SCALE
, C.NULLABLE
FROM SYS.CDC_CHANGE_TABLES$ S
, DBA_TABLES T
, DBA_TAB_COLUMNS C
WHERE S.CHANGE_TABLE_SCHEMA=T.OWNER AND S.CHANGE_TABLE_NAME=T.TABLE_NAME AND C.OWNER=S.CHANGE_TABLE_SCHEMA AND C.TABLE_NAME=S.CHANGE_TABLE_NAME AND C.COLUMN_NAME NOT IN ('OPERATION$'
, 'CSCN$'
, 'DDLDESC$'
, 'DDLPDOBJN$'
, 'DDLOPER$'
, 'RSID$'
, 'SOURCE_COLMAP$'
, 'TARGET_COLMAP$'
, 'COMMIT_TIMESTAMP$'
, 'TIMESTAMP$'
, 'USERNAME$'
, 'ROW_ID$'
, 'XIDUSN$'
, 'XIDSLT$'
, 'XIDSEQ$'
, 'SYS_NC_OID$')