oracle 字符串分割

123,abc,opq 转变为

123 1
abc 2
opq 3

select regexp_substr('123,abc,opq', '[^,]+', 1, level) a, level
  from dual
connect by level <=
           length('123,abc,opq') - length(replace('123,abc,opq', ',')) + 1