The GET_PARAM function is used to retrieve the default values of parameters for procedures in the DBMS_STATS package.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
DBMS_STATS.GET_PARAM (
pname IN VARCHAR2)
RETURN VARCHAR2;
Parameters
The pname parameter specifies the name of the parameter for which to retrieve the default value.
Exceptions
The error code OBE-20001 indicates an invalid input value.
Examples
Retrieve the default value of the METHOD_OPT parameter.
obclient> SELECT DBMS_STATS.GET_PARAM ('METHOD_OPT') FROM DUAL;
+-------------------------------------+
| DBMS_STATS.GET_PARAM ('METHOD_OPT') |
+-------------------------------------+
| FOR ALL COLUMNS SIZE AUTO |
+-------------------------------------+
1 row in set