728x90
반응형

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



728x90
반응형

+ Recent posts