[Oracle] 오라클 문자열 잘라내기

select trim(regexp_substr('a,b,c','[^,]+',1,LEVEL)) item_id,

trim(regexp_substr('1,2,3','[^,]+',1,LEVEL)) item_value

from dual

connect by level < 4

결과>

item_id	item_value
a	1
b	2
c	3