truncate table tablename;
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;
truncate table tablename;
select
'qianzui'||to_char(rownum) asname,from dual where rownum<1000000000 connect by level<=10000;