[Home] [Help] [Dependency Information]
Object Name: | _DBA_COMPARISON_SCAN |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPARISON_ID | NUMBER | Yes | ||
OWNER | VARCHAR2 | (128) | Yes | |
COMPARISON_NAME | VARCHAR2 | (128) | Yes | |
SCAN_ID | NUMBER | Yes | ||
PARENT_SCAN_ID | NUMBER | |||
STATUS | NUMBER | |||
CURRENT_DIF_COUNT | NUMBER | |||
INITIAL_DIF_COUNT | NUMBER | |||
ROOT_SCAN_ID | NUMBER | |||
COUNT_ROWS | NUMBER | |||
SCAN_NULLS | VARCHAR2 | (1) | ||
LAST_UPDATE_TIME | TIMESTAMP(6) | (11) |
Cut, paste (and edit) the following text to query this object:
SELECT COMPARISON_ID
, OWNER
, COMPARISON_NAME
, SCAN_ID
, PARENT_SCAN_ID
, STATUS
, CURRENT_DIF_COUNT
, INITIAL_DIF_COUNT
, ROOT_SCAN_ID
, COUNT_ROWS
, SCAN_NULLS
, LAST_UPDATE_TIME
FROM SYS._DBA_COMPARISON_SCAN;
|
|
|