oracle 一串字符转换为一列

select regexp_substr('0121;0312;0633;0825;0961','[^;]+',1,level) as typeCode
  from dual connect by level<=regexp_count('0121;0312;0633;0825;0961',';')+1;