废话不多说了，直接给大家贴代码了，具体代码如下所示：

CREATE OR REPLACE FUNCTION f_get_param(
IN_PARAM IN VARCHAR2,
IN_FLAG IN VARCHAR2)
RETURN VARCHAR2 IS
RESULT VARCHAR2(500);
v_leng NUMBER;
v_left NUMBER;
v_right NUMBER;
v_param VARCHAR2(200);
v_param1 VARCHAR2(200);
BEGION
RESULT := '';
v_param:=IN_PARAM;
v_leng := LENGTH(v_param);
v_left := instr(v_param,in_flag);
IF v_left > 0 THEN
v_param1 := substr(v_param,v_left,v_leng - v_left +1)
v_left := instr(v_param1,':') + 1;
v_right := indtr(v..