Oracle connect by

来源:互联网 发布:linux内核源代码分析 编辑:程序博客网 时间:2024/06/05 04:14

truncate table tablename;


insert into tablename(name,mobile,age,time)

select

'qianzui'||to_char(rownum) asname,
to_char(rownum+13800000000) as mobile,
30 as age,
sysdate as time,

from dual where rownum<1000000000 connect by level<=10000;


commit;
0 0
原创粉丝点击