Example of PL/SQL implementing the split() method in JAVA

As we all know, java provides the split() string splitting method for the String class, so it is easy to split the string into a string array using the specified symbol. However, pl/sql does not provide the split() method in java, so if you want to split strings in pl/sql, you need to do it yourself. Since I need to use this kind of method in the project, I studied it myself for future reference. Here, comma is used as the separator as an example. The code is as follows:

declare
v_str varchar2(200) := 'abd,324,u78,23f,sd09,2345,dsaf,9079';
type str_table_type is table of varchar2(50);
strArr str_table_type := str_table_type('');
v_index integer := 1;
begin
while (length(v_str)-length(replace(v_str,',',''))) > 0 loop
strArr(v_index) := substr(v_str,1,instr(v_str,',',1,1)-1);
v_str := substr(v_str,instr(v_str,',',1,1)+1);
strArr.extend;
v_index := v_index + 1;
end loop;
strArr(v_index) := v_str;
for i in strArr.first..strArr.last loop
dbms_output.put_line(strArr(i));
end loop;
end;

The above is the PL/SQL implementation of split( in JAVA introduced by the editor) ) method examples, I hope it will be helpful to everyone. If you want to know more, please pay attention to the PHP Chinese website!

For more examples of PL/SQL implementation of the split() method in JAVA, please pay attention to the PHP Chinese website for related articles!