例如:
cursor aa is
select * from a;for rec in aa loop
.
.
.end loop;
循环内或者外如何取记录数,不能用循环,用SQL%Rowcount也不好用啊?
cursor aa is
select * from a;for rec in aa loop
.
.
.end loop;
循环内或者外如何取记录数,不能用循环,用SQL%Rowcount也不好用啊?
select count(1) into i_count from a
i_count是记录数