DBA_COMPARISON_SCAN_VALUES

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

Related View

USER_COMPARISON_SCAN_VALUES displays details about the values for all comparison scans 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 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)   The time that this row was last updated