使用DBMS_UTILITY.get_parameter_value查看session的parameter
alter session set parallel_instance_group = 'denglt';
set SERVEROUTPUT on;
DECLARE
parnam VARCHAR2 (256);
intval BINARY_INTEGER;
strval VARCHAR2 (256);
partyp BINARY_INTEGER;
BEGIN
partyp :=
DBMS_UTILITY.get_parameter_value ('parallel_instance_group', intval, strval);
DBMS_OUTPUT.put ('parameter value is: ');
IF partyp = 1
THEN
DBMS_OUTPUT.put_line (strval);
ELSE
DBMS_OUTPUT.put_line (intval);
END IF;
IF partyp = 1
THEN
DBMS_OUTPUT.put ('parameter value length is: ');
DBMS_OUTPUT.put_line (intval);
END IF;
DBMS_OUTPUT.put ('parameter type is: ');
IF partyp = 1
THEN
DBMS_OUTPUT.put_line ('string');
ELSE
DBMS_OUTPUT.put_line ('integer');
END IF;
END;
/
parameter value is: denglt
parameter value length is: 6
parameter type is: string
PL/SQL procedure successfully completed.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/195110/viewspace-710119/ ，如需转载，请注明出处，否则将追究法律责任。
