oracle快速生成一百万条测试数据,表t_fensi_value,字段phone[varchar2(32)],fensivalue[varchar2(32)]。
insert into t_fensi_value
--随机手机号
select '1390' || lpad(trunc(dbms_random.value(1, 1000000)), 7, '0') as phone,
--10000000以内的粉丝值
trunc(dbms_random.value(0, 10000000)) as fensivalue from dual
connect by level <= 1000000
写这个主要参考了