NCUT-LB

原创 CY_NOTES_1

1.Oracle IN()使用子查询得出的字符串参数: SELECT * FROM tname WHERE tname.id IN ( SELECT *   FROM (SELECT REGEXP_SUBSTR('1,2,3,4', '[^,]+', 1, ROWNUM) n FROM dual CONNECT BY ROWNUM   WHERE n IS NOT NULL )/