oracle connect实例

oracle connect实例

1：
select date '2010-5-1' + level,
       trunc(dbms_random.value * 1000),
       'book1',
       level,
       100 * level
  from dual
connect by level < 10000;

2：
select date '2010-5-1' + rownum,
       trunc(dbms_random.value * 1000),
       'book1',
       rownum,
       100 * rownum
  from dual
connect by rownum < 10000