DBA Data[Home] [Help]

VIEW: SYS._USER_COMPARISON_ROW_DIF

Source

View Text - Preformatted

SELECT d."COMPARISON_ID",d."SCAN_ID",d."LOC_ROWID",d."RMT_ROWID",d."IDX_VAL",d."STATUS",d."LAST_UPDATE_TIME",d."SPARE1",d."SPARE2",d."SPARE3",d."SPARE4" FROM comparison_row_dif$ d, comparison$ c
WHERE d.comparison_id = c.comparison_id
AND user# = uid
View Text - HTML Formatted

SELECT D."COMPARISON_ID"
, D."SCAN_ID"
, D."LOC_ROWID"
, D."RMT_ROWID"
, D."IDX_VAL"
, D."STATUS"
, D."LAST_UPDATE_TIME"
, D."SPARE1"
, D."SPARE2"
, D."SPARE3"
, D."SPARE4"
FROM COMPARISON_ROW_DIF$ D
, COMPARISON$ C WHERE D.COMPARISON_ID = C.COMPARISON_ID AND USER# = UID