ALL_PUBLISHED_COLUMNS

ALL_PUBLISHED_COLUMNS describes all existing source table columns for which users have privileges.

Related Views

• DBA_PUBLISHED_COLUMNS describes all existing source column tables.

• USER_PUBLISHED_COLUMNS describes all existing source table columns for which a user has privileges.

  Column	Datatype	Description
  CHANGE_SET_NAME	VARCHAR2(30)	Name of the change set
  SOURCE_SCHEMA_NAME	VARCHAR2(30)	Table owner in the source system
  SOURCE_TABLE_NAME	VARCHAR2(31)	Table name in the source system
  PUB_ID	NUMBER	Publication identifier (change table object number)
  COLUMN_NAME	VARCHAR2(30)	Column name
  DATA_TYPE	VARCHAR2(30)	Column datatype
  DATA_LENGTH	NUMBER	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	CHAR(1)	Nulls allowed (Y |N)?