[Home] [Help] [Dependency Information]
Object Name: | DBA_COMPARISON_SCAN_VALUES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Details about a comparison scan's values
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of comparison |
COMPARISON_NAME | VARCHAR2 | (128) | Yes | Name of comparison |
SCAN_ID | NUMBER | Yes | Scan id of scan | |
COLUMN_POSITION | NUMBER | Yes | Column position as in dba_comparison_columns | |
MIN_VALUE | VARCHAR2 | (4000) | Minimum value of scan | |
MAX_VALUE | VARCHAR2 | (4000) | Maximum value of scan | |
LAST_UPDATE_TIME | TIMESTAMP(6) | (11) | The time that this row was updated |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, COMPARISON_NAME
, SCAN_ID
, COLUMN_POSITION
, MIN_VALUE
, MAX_VALUE
, LAST_UPDATE_TIME
FROM SYS.DBA_COMPARISON_SCAN_VALUES;
|
|
|