SELECT DISTINCT regexp_substr(a.sbhdxh,'[^,]+', 1, level) from (SELECT sbhdxh FROM hddyb WHERE instr(sbhdxh,',')>0) a
connect by regexp_substr(a.sbhdxh, '[^,]+', 1, level) is not NULL
Oracle将查询出来的结果根据逗号拆分为可以作查询条件的语句
最新推荐文章于 2024-05-12 07:30:00 发布