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: PL/SQL : SELECT INTO

Re: PL/SQL : SELECT INTO

From: Karsten Schmidt <groups_at_karsten-schmidt.com>
Date: 26 Apr 2002 06:49:44 -0700
Message-ID: <c6711ac4.0204260549.7f32f456@posting.google.com> 





Hi,


 i would definately favour Option 1.


 As a matter of fact, option 2 has a race condition, in that the content
 of your table can change between your two queries. 



Karsten
Received on Fri Apr 26 2002 - 08:49:44 CDT












Original text of this message













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