循环插入数据
begin
for i in 1001 .. 1625
loop
insert into t2 (id)
values(i);
end loop;
commit;
end;
查询重复数据
select * from t1
where da in (select da from t1 group by da having count
(da) > 1) order by da
查询缺失数据
select a.id from t2 a
minus
select b.da from t1 b