Re: Top 5 Hitters?

In article <Pine.SOL.3.91.950729162615.8751A-100000_at_eniac>, Frank Talbott <talbof_at_eniac> says:

Hi,

Why don't you use a rownum condition in the where clause instead of using a for loop ?

Try something like
cursor c1 is
select * from table where conditions and rownum <=5;

open c1;
loop

   fetch c1;
   exit when c1%notfound;
   ...
end loop;

You get back only the row you want and save your network. Received on Thu Aug 10 1995 - 00:00:00 CEST