/* 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博客 ” ,链接:http://blog.itpub.net/23307206/viewspace-1052570/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23307206/viewspace-1052570/