VIEW: SYS._DBA_COMPARISON_SCAN

Source

View Text - Preformatted

SELECT
  r.comparison_id              comparison_id,
  u.name                       owner,
  r.comparison_name            comparison_name,
  s.scan_id                    scan_id,
  s.parent_scan_id             parent_scan_id,
  s.status                     status,
  s.spare1                     current_dif_count,
  s.spare2                     initial_dif_count,
  s.spare3                     root_scan_id,
  s.num_rows                   count_rows,
  decode(bitand(s.flags, 1), 1, 'Y', 'N') scan_nulls,
  s.last_update_time           last_update_time
FROM comparison_scan$ s, comparison$ r, user$ u
WHERE
    s.comparison_id = r.comparison_id
AND r.user# = u.user#

View Text - HTML Formatted

SELECT R.COMPARISON_ID COMPARISON_ID
, U.NAME OWNER
, R.COMPARISON_NAME COMPARISON_NAME
, S.SCAN_ID SCAN_ID
, S.PARENT_SCAN_ID PARENT_SCAN_ID
, S.STATUS STATUS
, S.SPARE1 CURRENT_DIF_COUNT
, S.SPARE2 INITIAL_DIF_COUNT
, S.SPARE3 ROOT_SCAN_ID
, S.NUM_ROWS COUNT_ROWS
, DECODE(BITAND(S.FLAGS
, 1)
, 1
, 'Y'
, 'N') SCAN_NULLS
, S.LAST_UPDATE_TIME LAST_UPDATE_TIME FROM COMPARISON_SCAN$ S
, COMPARISON$ R
, USER$ U WHERE S.COMPARISON_ID = R.COMPARISON_ID AND R.USER# = U.USER#