巧用CONNECT BY 造数据

SELECT ROWNUM AS ID
      ,TO_CHAR(SYSDATE + ROWNUM / 24 / 3600, 'yyyy-mm-dd hh24:mi:ss') AS INC_DATETIME
      ,TRUNC(DBMS_RANDOM.VALUE(0, 100)) AS RANDOM_ID
      ,DBMS_RANDOM.STRING('x', 20) RANDOM_STRING
  FROM DUAL
CONNECT BY LEVEL <= 10;

   SELECT '('||WMSYS.WM_CONCAT(':P' || ROWNUM)||')' V_SQL  FROM DUAL
   CONNECT BY LEVEL <=4;