见下面几个语句 (请问为什么第三个语句插入的数据只有一条, where 和 connect by的区别):
create table t1 as select rownum as id, rownum+1 as id2 from dual connect by level<=5;
select * from t1
create table t2 as select rownum as id, rownum+1 as id2 from dual connect by rownum <=5;
select * from t2
create table t3 as select rownum as id, rownum+1 as id2 from dual where rownum <=5;
select * from t3
守着星空守着你
慕桂英3389331
相关分类