ALL_PUBLISHED_COLUMNS

ALL_PUBLISHED_COLUMNS describes the published source table columns accessible to the current user. This view is intended for use by Change Data Capture subscribers. This view does not display the CHANGE_TABLE_SCHEMA or CHANGE_TABLE_NAME columns.

Related Views

DBA_PUBLISHED_COLUMNS describes all published source table columns in the database.
USER_PUBLISHED_COLUMNS describes the published source table columns owned by the current user. This view does not display the CHANGE_TABLE_SCHEMA or CHANGE_TABLE_NAME columns.

Column	Datatype	NULL	Description
`CHANGE_SET_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the change set
`CHANGE_TABLE_SCHEMA`	`VARCHAR2(30)`	`NOT NULL`	Associated change table owner
`CHANGE_TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Associated change table name
`PUB_ID`	`NUMBER`	`NOT NULL`	Publication identifier
`SOURCE_SCHEMA_NAME`	`VARCHAR2(30)`	`NOT NULL`	Table owner in the source database
`SOURCE_TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Table name in the source database
`COLUMN_NAME`	`VARCHAR2(30)`	`NOT NULL`	Column name
`DATA_TYPE`	`VARCHAR2(106)`		Column datatype
`DATA_LENGTH`	`NUMBER`	`NOT NULL`	Column length (in bytes)
`DATA_PRECISION`	`NUMBER`		Decimal precision for `NUMBER` datatype; binary precision for `FLOAT` datatype; `NULL` for all other datatypes
`DATA_SCALE`	`NUMBER`		Digits to the right of a decimal point in a number
`NULLABLE`	`VARCHAR2(1)`		Indicates whether nulls are allowed (`Y`) or not (`N`)