導(dǎo)讀:1建站知識(shí)oracle 將以逗號(hào)隔開(kāi)的字符串營(yíng)銷(xiāo)型網(wǎng)站建設(shè)網(wǎng)站推廣優(yōu)化seo。

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 ('85,86', ',')), 0) CNT FROM DUAL) t, (SELECT LEVEL lv FROM DUAL CONNECT BY LEVEL <= LENGTH('85,86,87' || ',') - NVL(LENGTH(REPLACE('85,86,87', ',')), 0)) c WHERE T.cnt >= c.lv說(shuō)明：CNT表示串里面有多少字符。當(dāng)是字符串是表中的字段時(shí)，取level<=最大個(gè)數(shù)如：１）.取最大個(gè)數(shù)SELECT MAX(LENGTH(RPT_ID || ',') - NVL(LENGTH(REPLACE(RPT_ID, ',')), 0)) INTO 建設(shè)網(wǎng)站v_c FROM DIM_AUDIT_TABLE@sjmh_inter;２）.l轉(zhuǎn)成行SELECT T.T_NAME, T.T_NAME_COMM, T.T_COLUMN, T.T_COLUMN_COMM, t.COMMENT_NL, t.COMMENT_NL_TIME,seo網(wǎng)站優(yōu)化 t.SEQ_USER_ID, 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 A.T_NAME, A.T_NAME_COMM, A.T_COLUMN, A.T_COLUMN_COMM, a.COMMENT_NL, a.COMMENT_NL_TIME, a.SEQ_USER_ID, '','' || A.RPT_ID || '','' RPT_ID, LENGTH(A.RPT_ID || '','') - NVL(LENGTH(REPLACE(A.RPT_ID, '','')), 0) CNT FROM DIM_AUDIT_TABLE@sjmh_inter A WHERE a.COMMENT_NL is not null) T, (SELECT LEVEL LV FROM DUAL CONNECT BY LEVEL <= '||v_c||') C WHERE C.LV <= T.CNT;

注:如果是上面代碼是遠(yuǎn)程的代碼,(SELECT LEVEL LV FROM DUAL CONNECT BY LEVEL <= '||v_c||') C,不要用dual表,可以網(wǎng)站seo優(yōu)化培訓(xùn)改用all_objects或user_objects, 要不然能查詢(xún),但是把查詢(xún)出來(lái)的SQL插入到某個(gè)表時(shí),只能插入一行

關(guān)鍵詞標(biāo)簽: 轉(zhuǎn)成 字符串