Re: SQL Help

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Thu, 22 Apr 1999 21:28:55 -0700
Message-ID: <371FF707.225C@oriolecorp.com>

begin

     select COL_A
     into a_variable
     from TABLE
     where TABLE.COL_B = value

 exception

    when no_data_found then

       a_variable := NULL;
 end;

--
Regards,

  Stéphane Faroult
  Oriole Corporation

---

http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs

---

Received on Thu Apr 22 1999 - 23:28:55 CDT