Oracle 字符串分割

来源：互联网发布：select js 选中value 编辑：程序博客网时间：2024/06/05 21:05

declare  str varchar2(100) := 'a,fweed,rfw,ew;wef,efw,f,we;aa,gg,ew,oaef';  str_idx integer;  str_crr varchar2(100);  str_idx2 integer;  str_crr2 varchar2(100);begin  loop    str_idx := Instr(str, ';', 1, 1);    exit when str_idx = 0;    str_crr := Substr(str, 1, str_idx-1);    --DBMS_OUTPUT.PUT_LINE(str_crr);    loop      str_idx2 := Instr(str_crr, ',', 1, 1);      exit when str_idx2 = 0;      str_crr2 := Substr(str_crr, 1, str_idx2-1);      str_crr := Substr(str_crr, str_idx2+1);      DBMS_OUTPUT.PUT_LINE(str_crr2);    end loop;    DBMS_OUTPUT.PUT_LINE(str_crr);    str := Substr(str, str_idx+1);    --DBMS_OUTPUT.PUT_LINE(str_idx);    DBMS_OUTPUT.PUT_LINE('---------------');    --DBMS_OUTPUT.PUT_LINE(str);  end loop;  loop    str_idx := Instr(str, ',', 1, 1);    exit when str_idx = 0;    str_crr := Substr(str, 1, str_idx-1);    str := Substr(str, str_idx+1);    DBMS_OUTPUT.PUT_LINE(str_crr);  end loop;  DBMS_OUTPUT.PUT_LINE(str);end;

0 0