(new StringBuffer(" SELECT ID FROM (?? ")).append((new StringBuilder()).append(" WITH A AS (SELECT '").append(s).append("' ID FROM DUAL)SELECT REGEXP_SUBSTR(ID,").toString()).append(" '[^,]+',? 1,ROWNUM) ID FROM A CONNECT BY ROWNUM <=").append(" LENGTH(REGEXP_REPLACE(ID,'[^,]+')) + 1)");這里的s的值為14002我所連起來的是這樣的，SELECT ID FROM (??? WITH A AS (SELECT '14002' ID FROM DUAL)SELECT REGEXP_SUBSTR(ID, '[^,]+',? 1,ROWNUM) ID FROM A CONNECT BY ROWNUM <= LENGTH(REGEXP_REPLACE(ID,'[^,]+')) + 1)) s但是總感覺不對