The GET_PARAM function is used to retrieve the default values of parameters for procedures in the DBMS_STATS system package.
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 HY000 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