| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
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) |