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
(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