字符串拆分--For Oracle

/* 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_newFROM g_test_dup_rate t,(SELECT ROWNUM rnFROM all_objectsWHERE ROWNUM <= 20)WHERE INSTR (',' || t.defect_code || ',', ',', 1, rn + 1) > 0AND t.defect_code IS NOT NULLORDER BY t.serial_number,rn;

上面工作中一个简单的oracle数据库下拆分字符串方法！