oracle存储超长字符串比较，ORACLE存储过程.docVIP

 ORACLE存储过程-分割字符串 create or replace procedure split (is_sourcestr IN VARCHAR2, is_regstr IN sourcestr_start int := o; TYPE table_name_type IS TABLE OF VARCHAR2 (32); va_table_nametable_name_type; sourcestr_next int := O; varchar2(50); vs_sourcestr2 regstr_length int:=0; vs_varray_length int:=0; regstr_length:=length(is_regstr); vs_sourcestr2:=is_sourcestr; va_table_name :=table_name_type(is_sourcestr); while regstr_length0 L00P sourcestr_next := instr(vs_sourcestr2,is_regstr); IF sourcestr_next 0 THEN if sourcestr_start = o then sourcestr_start := l; va_table_name.extend(i); va_table_name(va