GET_PARAM

The GET_PARAM function is used to obtain the default value of a parameter of a procedure 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 whose default value is to be obtained.

Exceptions

The error code HY000 indicates an invalid input value.

Examples

Obtain the default value of the METHOD_OPT parameter.

SELECT DBMS_STATS.GET_PARAM ('METHOD_OPT') FROM DUAL;
+-------------------------------------+
| DBMS_STATS.GET_PARAM ('METHOD_OPT') |
+-------------------------------------+
| FOR ALL COLUMNS SIZE AUTO           |
+-------------------------------------+
1 row in set