V$PARAMETER_VALID_VALUES displays a list of valid values for list parameters.
| Column | Datatype | Description |
|---|---|---|
NUM |
NUMBER |
Parameter number |
NAME |
VARCHAR2(64) |
Parameter name |
ORDINAL |
NUMBER |
Ordinal number in the list (1-based) |
VALUE |
VARCHAR2(255) |
Parameter value at ordinal |
ISDEFAULT |
VARCHAR2(64) |
Indicates whether the given ordinal value is the default value for the parameter |