把字符串按照分割符分解成不同的部分
來源：懂視網(wǎng)
責編：小采
時間：2020-11-09 15:02:08
把字符串按照分割符分解成不同的部分
把字符串按照分割符分解成不同的部分:select regexp_substr('A,B,C,D,E', '[^,]', 1, level, 'i') as str from dual connect by level = length('A,B,C,D,E') - length(regexp_replace('A,B,C,D,E', ',', '')) 1; select regexp_substr('A,B,C,D,E', '[^,]+', 1, level, 'i') as str from du
導讀把字符串按照分割符分解成不同的部分:select regexp_substr('A,B,C,D,E', '[^,]', 1, level, 'i') as str from dual connect by level = length('A,B,C,D,E') - length(regexp_replace('A,B,C,D,E', ',', '')) 1; select regexp_substr('A,B,C,D,E', '[^,]+', 1, level, 'i') as str from du
select regexp_substr('A,B,C,D,E', '[^,]', 1, level, 'i') as str from dual connect by level = length('A,B,C,D,E') - length(regexp_replace('A,B,C,D,E', ',', '')) 1;
select regexp_substr('A,B,C,D,E', '[^,]+', 1, level, 'i') as str
from dual
connect by level <=
length('A,B,C,D,E') - length(regexp_replace('A,B,C,D,E', ',', '')) + 1;
聲明：本網(wǎng)頁內容旨在傳播知識，若有侵權等問題請及時與本網(wǎng)聯(lián)系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
把字符串按照分割符分解成不同的部分
把字符串按照分割符分解成不同的部分:select regexp_substr('A,B,C,D,E', '[^,]', 1, level, 'i') as str from dual connect by level = length('A,B,C,D,E') - length(regexp_replace('A,B,C,D,E', ',', '')) 1; select regexp_substr('A,B,C,D,E', '[^,]+', 1, level, 'i') as str from du
