原创

Oracle connect by生成大量数据

create table conn_by as
with data_gen as
(select /*+materialize*/ rownum rid
from dual
connect by level<1000
)
select rpad('z',10,rownum) p_data
from data_gen t1,data_gen t2,data_gen t3
where rownum <=1000000;
正文到此结束
该篇文章的评论功能已被站长关闭