DBA Data[Home] [Help]

VIEW: SYS.USER_COMPARISON_SCAN

Source

View Text - Preformatted

SELECT comparison_name, scan_id, parent_scan_id, root_scan_id, status,
          current_dif_count, initial_dif_count, count_rows,
          scan_nulls, last_update_time
FROM dba_comparison_scan
WHERE owner = SYS_CONTEXT('USERENV','CURRENT_USER')
View Text - HTML Formatted

SELECT COMPARISON_NAME
, SCAN_ID
, PARENT_SCAN_ID
, ROOT_SCAN_ID
, STATUS
, CURRENT_DIF_COUNT
, INITIAL_DIF_COUNT
, COUNT_ROWS
, SCAN_NULLS
, LAST_UPDATE_TIME FROM DBA_COMPARISON_SCAN WHERE OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')