oracle 拆分存储过程（双分隔符拆分）

自定义字符拆分存储过程（双分隔符拆分）

CREATE OR REPLACE PROCEDURE GET_SUB_STR(V_NAMES       IN VARCHAR2,
                                        V_SPLIT       IN VARCHAR2,
                                        V_CHILD_SPLIT IN VARCHAR2) IS
  V_NUM   NUMBER;
  V_NO    VARCHAR2(3000);
  V_NAME  VARCHAR2(4000);
  V_VALUE VARCHAR2(4000);
  V_NO1   VARCHAR2(1000);
BEGIN
  DELETE COMMON_DATA_TMP;

  COMMIT;
  V_NAME :=