Re: Question on Proper Use of EXISTS

Declare
  kount number;
Begin
  select count(*)
   into kount
   from mytable
   where id = :old.id;

  if kount > 0 then
    ......
  end if;
end; Received on Fri Mar 30 2001 - 18:14:19 CST