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.
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) |