create or replace procedure nethelp_gettops is
v_id T_ALARM_STATE@NTALARM.id%TYPE;
//这样表示很方便
CURSOR c_alarm IS SELECT "id"
//注意双引号
FROM T_ALARM_STATE@NTALARM ;
//远程数据库的游标
BEGIN
for cursor1 in c_alarm
//遍历一下
loop
v_id := cursor1.id;
DBMS_OUTPUT.PUT_LINE(v_id );
END loop;
//无关紧要,示范一下
execute immediate 'insert into nethelp_datas(data1,data2)
(select "user_label",count(1)
from T_ALARM_STATE_FINISH@NTALARM
where "source_id" = ''华为T2000-SDH环市局网管''
//注意这里要字符转义,两个单
引号
and "mediation_time" >=''2008-12-03 00:00:00''
//这里不对,实在不行就传参数
and "mediation_time" <=''2008-12-10 00:00:00'' a
nd "priority" <5
group by "user_label")';
end nethelp_gettops;