Oracle® Database Reference 11g Release 2 (11.2) Part Number E17110-08 |
|
|
PDF · Mobi · ePub |
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 ) |