oracle園地

description='111,222,333,444,555,666,777,888,999,101'

select

nvl(substr(description, 1,instr(description, ',', 1, 1)-1),'無') one,

nvl(substr(description, instr(description, ',', 1, 1)+1, instr(description, ',', 1, 2) - instr(description, ',', 1, 1)-1),'無') two,

nvl(substr(description, instr(description, ',', 1, 2)+1, instr(description, ',', 1, 3) - instr(description, ',', 1, 2)-1),'無') three,

nvl(substr(description, instr(description, ',', 1, 3)+1, instr(description, ',', 1, 4) - instr(description, ',', 1, 3)-1),'無') four,

nvl(substr(description, instr(description, ',', 1, 4)+1, instr(description, ',', 1, 5) - instr(description, ',', 1, 4)-1),'無') five,

nvl(substr(description, instr(description, ',', 1, 5)+1, instr(description, ',', 1, 6) - instr(description, ',', 1, 5)-1),'無') six,

nvl(substr(description, instr(description, ',', 1, 6)+1, instr(description, ',', 1, 7) - instr(description, ',', 1, 6)-1),'無') serven,

nvl(substr(description, instr(description, ',', 1, 7)+1, instr(description, ',', 1, 8) - instr(description, ',', 1, 7)-1),'無') eight,

nvl(substr(description, instr(description, ',', 1, 8)+1, instr(description, ',', 1, 9) - instr(description, ',', 1, 8)-1),'無') nine,

nvl(substr(description, instr(description, ',', -1)+1),'無' )Last

from dual;