USER_PUBLISHED_COLUMNS

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

Column	Datatype	Description
SOURCE_SCHEMA_NAME	VARCHAR2(30)	Table owner in the source system
SOURCE_TABLE_NAME	VARCHAR2(31)	Table name in the source system
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)?