大家好,又见面了,我是你们的朋友全栈君。
SELECT distinct REGEXP_SUBSTR(t.llbm1, ‘[^;]+’, 1, LEVEL, ‘i’) AS STR FROM user_nbgzlld t, cpcshtins s where t.shtinsid = s.shtinsid and s.wfid = 35 connect by level<= (regexp_count(t.llbm1,’;’)+1)
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/129624.html原文链接:https://javaforall.net