Oracle Multi-parameter query statement _oracle

Nonsense not to say more, directly to everyone to paste the code, the specific code as follows:

CREATE OR REPLACE FUNCTION f_get_param (In_param in VARCHAR2, In_flag in VARCHAR2) return VARCHAR2 is RES 
ULT 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_param1, ' $ '); 
 Result: = substr (v_param1,v_left,v_right-v_left) end IF; 
 return (result); 
EXCEPTION when others THEN return "; 
End F_get_param;  Database Assignment Format F_get_param (V_param, ' materialtype: ');//device encoding type//database display public string buildtoparams (Listargs Args) {string 
  params = ' $ '; if (Args!= null) {if (!string.isnotempty (Args.materailtype)) {params = params + ' materialtypes: ' + Ar Gs. 
    Materailtype + ' $ '; 
} return params; //oracle Database Extensions-Multiple selection parameters Select InStr(',' || ' 1,2,3,21 ' | | ',',',' || ' 1 ' | | ', '] from DUAL SELECT * table_name where InStr (', ' | | list_id | | ',',',' || ID | | ', ' > 0//oarcle ', ' separate query select DISTINCT regexp_substr (' I Love you ', ' [^.]  + ', 1,rownum xyz_name from dual connect by rownum <= length (' I love you ')-Length (replace (' I love you ', ', ')) + 1

The above is a small set to introduce the Oracle Multi-parameter query statements, I hope to help you, if you have any questions welcome to my message, small series will promptly reply to everyone!