Chinaunix

标题: 巧用CONNECT BY 造数据 [打印本页]

---

作者: hhuxyb    时间: 2011-12-23 03:10
标题: 巧用CONNECT BY 造数据

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;

---

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)

Powered by Discuz! X3.2