关于：转成行の话题！

oracle 字符串转成行

• 陌路离殇 发布于 2009-06-15 20:38
• 收藏 oracle 字符串 转成行

SELECT SUBSTR (T.RPT_ID, INSTR (T.RPT_ID,',',1,C.LV)+ 1, INSTR (T.RPT_ID,',',1,C.LV + 1)- (INSTR (T.RPT_ID,',',1,C.LV)+ 1)) AS RPT_ID FROM (SELECT ',' || '85,86,87' || ',' RPT_ID, LENGTH ('85,86,87' || ',') - NVL (LENGTH (REPLACE ..