两个字符串数组是否相互包含

最新推荐文章于 2024-04-17 08:37:19 发布

u014519127

最新推荐文章于 2024-04-17 08:37:19 发布

阅读量227

点赞数

文章标签： oracle

本文链接：https://blog.csdn.net/u014519127/article/details/121078237

版权

declare

a varchar2(200) ;--当前cqi
b varchar2(200) ;--当前cqi
aa varchar2(200) ;--当前cqi
bb varchar2(200) ;--当前cqi
aa_sequence varchar2(200) ;--当前cqi
bb_sequence varchar2(200) ;--当前cqi
begin
a:='1,3';
b:='3,2,1,5';
select wm_concat(column_value) into aa_sequence from (select column_value from table(splitstr(a, ',')) order by column_value asc);
select wm_concat(column_value) into bb_sequence from (select column_value from table(splitstr(b, ',')) order by column_value asc);
-- dbms_output.put_line('aa_sequence'||aa_sequence);
-- dbms_output.put_line('bb_sequence'||bb_sequence);
if aa_sequence=bb_sequence then
dbms_output.put_line('调整数据顺序a,b一样');
else
select wm_concat(column_value) into aa from (select column_value from table(splitstr(b, ',')) union select column_value from table(splitstr(a, ',')));
dbms_output.put_line('aa'||aa);
if aa=bb_sequence then
dbms_output.put_line('a全包含');
else
if aa=aa_sequence then
dbms_output.put_line('b全包含');
else
dbms_output.put_line('a,b不能相互全包含');
end if ;
end if ;
end if ;

end ;