【求助】求一语句
test_item_name pointer_condition_text pointer_condition_text2a a<1;b<=5 b c d <998
test_item_nameacd
with t1 as( select 'a' c1,null c2,'a<1;b<=5' c3 from dual union all select 'b' c1,null c2,null c3 from dual union all select 'c' c1,null c2,null c3 from dual union all select 'd' c1,'<998' c2,null c3 from dual)select distinct c1from t1,( select replace(regexp_substr(c3,'[^;]+',1,level),';',' ') val from t1 connect by level<=length(c3)-length(replace(c3,';',''))+1) t2 where length(replace(val,c1,'')) < length(val) or c2 is not nullorder by c1 c1----------------1 a2 b3 d