create procedure p_insert as begin INSERT INTO unicom.gsm_list SELECT CALLTYPE,ACCESS_NUMBER,CALLED_NUMBER FROM GSM_USAGE_CHARGE_TABLE_200303@server10 WHERE access_number like '1317791%' and CREATED_DATE>=to_date('20030313','yyyymmdd') and CREATED_DATE<=to_date('20030319','yyyymmdd'); end; / begin for i in 1..n loop p_insert; end loop; end; /
as
begin
INSERT INTO unicom.gsm_list SELECT CALLTYPE,ACCESS_NUMBER,CALLED_NUMBER FROM GSM_USAGE_CHARGE_TABLE_200303@server10 WHERE access_number like '1317791%' and CREATED_DATE>=to_date('20030313','yyyymmdd') and CREATED_DATE<=to_date('20030319','yyyymmdd');
end;
/
begin
for i in 1..n loop
p_insert;
end loop;
end;
/
或在Oracle自带的SQL WorkSheet里面运行