VIEW: SYS.DBA_COMPARISON_SCAN_VALUES

Source

View Text - Preformatted

SELECT
  u.name              owner,
  r.comparison_name   comparison_name,
  v.scan_id           scan_id,
  v.column_position   column_position,
  v.min_val           min_value,
  v.max_val           max_value,
  v.last_update_time
FROM
  comparison$ r, user$ u, comparison_scan_val$ v
WHERE
    v.comparison_id = r.comparison_id
AND r.user# = u.user#

View Text - HTML Formatted

SELECT U.NAME OWNER
, R.COMPARISON_NAME COMPARISON_NAME
, V.SCAN_ID SCAN_ID
, V.COLUMN_POSITION COLUMN_POSITION
, V.MIN_VAL MIN_VALUE
, V.MAX_VAL MAX_VALUE
, V.LAST_UPDATE_TIME FROM COMPARISON$ R
, USER$ U
, COMPARISON_SCAN_VAL$ V WHERE V.COMPARISON_ID = R.COMPARISON_ID AND R.USER# = U.USER#