从学会做人开始认识这个世界!http://volnet.github.io
insert into adl_addressvalue
(adv_id, adv_adt_id, adv_value, adv_owner)
select rownum + 4 adv_id,
decode(MOD(rownum, 2), 0, 2, 1) adv_adt_id,
decode(MOD(rownum, 2),
0,
'' || (13799308000 + rownum / 2),
'张三' ||
decode(MOD(rownum, 2), 0, rownum / 2, (rownum + 1) / 2)) adv_value,
decode(MOD(rownum, 2),
0,
'' || (103 + (rownum / 2)),
'' || (103 + (rownum / 2) + 0.5)) adv_owner
from all_objects
where rownum < 10000