艾泽拉斯游记

declare
  pos  number;
  pos1 number;
  pos2 number;
  num  number;
  matchid varchar2(1000);
begin
  pos1 := 1;
  num := 1;
  matchid:='123,123123.sd234as,asaaa';
  loop  
    if (pos is not null) then
      pos1 := pos + 1;
    end if;
    pos := instr(matchid, ',',1,num);
    pos2 := pos - pos1;
    if (pos = 0 and num!=1) then
      pos2 := length(matchid);
    end if;
    if (trim(substr(matchid, pos1, pos2)) is not null) then
      DBMS_OUTPUT.PUT_LINE(trim(substr(matchid, pos1, pos2)));
    end if;
    num := num + 1;
    exit when pos is null or pos = 0 o