[Home] [Help] [Dependency Information]
Object Name: | ORDDCM_PREFS_LOOKUP |
---|---|
Object Type: | TABLE |
Owner: | ORDDATA |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_C00241408 | NORMAL | UNIQUE | SYSTEM | PARAM_NAME |
SYS_C00241409 | NORMAL | UNIQUE | SYSTEM | VALID_STR_VALUES |
SYS_C00241410 | NORMAL | UNIQUE | SYSTEM | DEFAULT_STR_VALUES |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARAM_NAME | VARCHAR2 | (64) | Yes | |
PARAM_TYPE | VARCHAR2 | (15) | Yes | |
MIN_VAL | NUMBER | |||
MAX_VAL | NUMBER | |||
DEFAULT_NUMBER_VAL | NUMBER | |||
DEFAULT_STR_VAL | VARCHAR2 | (1999) | ||
DEFAULT_STR_VALUES | ORD_STR_LIST | (16) | ||
VALID_STR_VALUES | ORD_STR_LIST | (16) | ||
PARAM_DESC | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT PARAM_NAME
, PARAM_TYPE
, MIN_VAL
, MAX_VAL
, DEFAULT_NUMBER_VAL
, DEFAULT_STR_VAL
, DEFAULT_STR_VALUES
, VALID_STR_VALUES
, PARAM_DESC
FROM ORDDATA.ORDDCM_PREFS_LOOKUP;
|
|
|