巧用CONNECT BY 造数据

hhuxyb

1. SELECT ROWNUM AS ID
   
2.       ,TO_CHAR(SYSDATE + ROWNUM / 24 / 3600, 'yyyy-mm-dd hh24:mi:ss') AS INC_DATETIME
   
3.       ,TRUNC(DBMS_RANDOM.VALUE(0, 100)) AS RANDOM_ID
   
4.       ,DBMS_RANDOM.STRING('x', 20) RANDOM_STRING
   
5.   FROM DUAL
   
6. CONNECT BY LEVEL <= 10;
   
7.   
   
8.    SELECT '('||WMSYS.WM_CONCAT(':P' || ROWNUM)||')' V_SQL FROM DUAL
   
9.    CONNECT BY LEVEL <=4;