Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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

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)