/* Formatted on 2011/07/12 16:54 (Formatter Plus v4.8.8) */
SELECT DISTINCT t.serial_number, t.defect_code,rn,
SUBSTR (t.defect_code,
INSTR (',' || t.defect_code || ',', ',', 1, rn),
INSTR (',' || t.defect_code || ',', ',', 1, rn + 1)
- INSTR (',' || t.defect_code || ',', ',', 1, rn)
- 1
) AS str_new
FROM g_test_dup_rate t,
(SELECT ROWNUM rn
FROM all_objects
WHERE ROWNUM <= 20)
WHERE INSTR (',' || t.defect_code || ',', ',', 1, rn + 1) > 0
AND t.defect_code IS NOT NULL
ORDER BY t.serial_number,rn;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23307206/viewspace-1052570/ ，如需转载，请注明出处，否则将追究法律责任。
