Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Help

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US