Re: Quickest/Efficent Row Exist!

From: DonWoods <donwoods_at_aol.com>
Date: 1996/07/29
Message-ID: <4thm1o$heh_at_newsbf02.news.aol.com>#1/1

If you can use a cursor then
declare
cursor c is select 1 from tech where r_code='TECH1234'; i binary_integer;
begin
...
  open c; -- open the cursor
  fetch c into i; --fetch only one row
  if c%notfound then
    i := 0;
  end if;
  close c; -- close the cursor.
  return i;

---

You can package this in a function or
procedure to return the value(s)
to your calling routine. Received on Mon Jul 29 1996 - 00:00:00 CEST