Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_COMPARISON_SCAN_VALUES

DBA_COMPARISON_SCAN_VALUES displays information about the values for all comparison scans in the database.

Related View

USER_COMPARISON_SCAN_VALUES displays information about the values for the comparison scans 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 scan
COMPARISON_SCAN VARCHAR2(30) NOT NULL Name of the comparison scan
SCAN_ID NUMBER NOT NULL Scan ID
COLUMN_POSITION NUMBER NOT NULL Column position, as in DBA_COMPARISON_COLUMNS
MIN_VALUE VARCHAR2(4000)   Minimum value of the scan
MAX_VALUE VARCHAR2(4000)   Maximum value of the scan
LAST_UPDATE_TIME TIMESTAMP(6)   Time that this row was last updated