The GET_PARAM function obtains the default values of parameters of procedures in the DBMS_STATS package.
Syntax
DBMS_STATS.GET_PARAM (
pname IN VARCHAR2)
RETURN VARCHAR2;
Parameters
The pname parameter specifies the name of the parameter whose default value is to be obtained.
Exceptions
The error code HY000 indicates that the input value is invalid.
Examples
Obtain 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