DBA_COMPARISON_COLUMNS displays details about the columns for all comparison objects in the database.
USER_COMPARISON_COLUMNS displays details about the columns for all comparison objects owned by the current user. This view does not have 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) |
Whether or not the column is an index column |