DBA_COMPARISON_COLUMNS displays information about the columns for all comparison objects in the database.
USER_COMPARISON_COLUMNS displays information about the columns for the comparison objects owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the comparison |
COMPARISON_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the comparison |
COLUMN_POSITION |
NUMBER |
NOT NULL |
Position of the column |
COLUMN_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the column |
INDEX_COLUMN |
VARCHAR2(1) |
Indicates whether the column is an index column (Y) or not (N) |