把b列中的数据用逗号分隔开这个偶做过，拆分逗号分隔符变列 select a, t.ca, c.lv,instr(t.ca, ‘,’, 1, c.lv) + 1, substr(t.ca, instr(t.ca, ‘,’, 1, c.lv) + 1, instr(t.ca, ‘,’, 1, c.lv + 1) – (instr(t.ca, ‘,’, 1, c.lv) + 1)) AS c from (select a, ‘,’ || b || ‘,’ AS ca, b, LENGTH(b), length(b || ‘,’), REPLACE(b, ‘,’), length(REPLACE(b, ‘,’)), –删除逗号的长度 nvl(length(REPLACE(b, ‘,’)), 0), –空值长度为空，因此要将空值替换为0 length(b || ‘,’) – nvl(length(REPLACE(b, ‘,’)), 0) AS cnt –以逗号分隔的字符串个数,先在原来的长度上加1 计算去除所有逗号后字符串长度，再，拿这个 FROM TEST_A) t, (select LEVEL lv from dual CONNECT BY LEVEL