create or replace procedure maomao_1217
as

for_date date;
for_btntid number;
test int;

CURSOR cur_date IS
select distinct t.thedate from domain_score t;
CURSOR cur_btntid IS
select distinct t.btntid from domain_score t;
begin
for for_date in cur_date loop

for for_btntid in cur_btntid loop

insert into domain_score_tmp
(select a.* from (select * from domain_score t where t.btntid=for_btntid and t.thedate=for_date order by t.score desc) a
where rownum < 100);

end loop;

---dbms_output.put_line('This NUMBER is '||for_btntid);
end loop;
end maomao_1217;

create or replace procedure maomao_1217
as

for_date2 date;
for_btntid2 number;
test int;

CURSOR cur_date IS
select distinct t.thedate from domain_score t;
CURSOR cur_btntid IS
select distinct t.btntid from domain_score t;
begin
for for_date in cur_date loop

for for_btntid in cur_btntid loop

insert into domain_score_tmp
(select a.* from (select * from domain_score t where t.btntid=for_btntid.btntid and t.thedate=for_date.thedate order by t.score desc) a
where rownum < 100);

end loop;

---dbms_output.put_line('This NUMBER is '||for_btntid.btntid);
end loop;
end maomao_1217;