VIEW: SYS.DBA_SOURCE_TAB_COLUMNS

Source

View Text - Preformatted

SELECT
  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
    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 LIKE '%$'

View Text - HTML Formatted

SELECT 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
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 LIKE '%$'