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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Always return at least one value

RE: Always return at least one value

From: <Stephen.Lee_at_DTAG.Com>
Date: Fri, 19 Mar 2004 12:25:55 -0600
Message-ID: <D6339830FC73944E889CC3CEADDB205B079092A1@bu-dtagpo1.tracs.com> 






And the results are:



Doing the extra query to determine the existence runs faster (on the data I
have here).  That was the only solution I could originally think of
(confirmed by Mark ... Thanks!), but I thought there HAD to be something
faster that avoided the existence check.



I will certainly hang on to the example from Stephane and hope I can
remember where I put it when I need it.





Please see the official ORACLE-L FAQ: http://www.orafaq.com




To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.


--



Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


Received on Fri Mar 19 2004 - 12:22:29 CST












Original text of this message













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