VIEW: SYS.USER_PUBLISHED_COLUMNS

Source

View Text - Preformatted

SELECT
   s.change_set_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, all_tables t, all_tab_columns c, sys.user$ u
  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$') AND
        s.change_table_schema = u.name AND
        u.user# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT S.CHANGE_SET_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
, ALL_TABLES T
, ALL_TAB_COLUMNS C
, SYS.USER$ U
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$') AND S.CHANGE_TABLE_SCHEMA = U.NAME AND U.USER# = USERENV('SCHEMAID')