select ... from ... group by ... having count(*)=1 的都是不重复的,having count(*)>1 的单独处理!
可以变通一下,定义一个变量作为零时存储的对象. declare r sys_refcursor; a tab%rowtype; TMP tab%rowtype; begin OPEN R FOR SELECT * FROM TAB; FETCH R INTO A; WHILE R%FOUND LOOP ..... 比较A和TMP. ... TMP:=A; FETCH R INTO A; END LOOP; end; 实际中还需要完善以便处理异常情况
group by ... having count(*)=1 的都是不重复的,having count(*)>1 的单独处理!
declare
r sys_refcursor;
a tab%rowtype;
TMP tab%rowtype;
begin
OPEN R FOR SELECT * FROM TAB;
FETCH R INTO A;
WHILE R%FOUND LOOP
.....
比较A和TMP.
...
TMP:=A;
FETCH R INTO A;
END LOOP;
end;
实际中还需要完善以便处理异常情况