Re: Q: To check a record's existence in a table, FAST!

Martin Schroeder wrote:
>

declare
cursor x is select blah from blah_blah;
begin
open x;
fetch x into y;
if %notfound then (0 rows)
else
  fetch x into y
  if %notfound then ( 1 rows)
  else
  (>1 rows)
end if;
close x;

-- 
Connor McDonald
Systems Administrator-Unix/Oracle
BHP Iron Ore
"You're not drunk if you can lie on the floor without holding on"
            - Dean Martin