如何在存储过程中拆分逗号分隔的字符串? [英] How to split comma separated string inside stored procedure?
本文介绍了如何在存储过程中拆分逗号分隔的字符串?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在存储过程中将逗号分隔的字符串拆分为字符串并将其插入表字段?
How to split comma separated string into strings inside store procedure and insert them into a table field?
使用Firebird 2.5
Using Firebird 2.5
推荐答案
以下是如何拆分字符串并将子字符串写入表格的示例:
Here a sample how to split the string and write the sub-strings into a table:
create procedure SPLIT_STRING (
AINPUT varchar(8192))
as
declare variable LASTPOS integer;
declare variable NEXTPOS integer;
declare variable TEMPSTR varchar(8192);
begin
AINPUT = :AINPUT || ',';
LASTPOS = 1;
NEXTPOS = position(',', :AINPUT, LASTPOS);
while (:NEXTPOS > 1) do
begin
TEMPSTR = substring(:AINPUT from :LASTPOS for :NEXTPOS - :LASTPOS);
insert into new_table("VALUE") values(:TEMPSTR);
LASTPOS = :NEXTPOS + 1;
NEXTPOS = position(',', :AINPUT, LASTPOS);
end
suspend;
end
这篇关于如何在存储过程中拆分逗号分隔的字符串?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文