这里的sql连起来是怎样的

Question

(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但是总感觉不对

Answer 1

肯定不对啊，就跟你学语文，主谓语都不对