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

Home -> Community -> Usenet -> c.d.o.misc -> Code review... gurus required!

Code review... gurus required!

From: Steve Holdoway <steve_at_itemfront.ltd.uk>
Date: Thu, 17 Jul 2003 09:24:13 +0000 (UTC)
Message-ID: <u2qchv8ufv72gm1ueeto10fmg2ish2s30u@4ax.com> 





Hi All,



I've been asked to do a code review, and came across this line...



   select nvl(count(*),0) into variable



...and I'm not sure if it is necessary! Do you need the nvl() function
in this pl/sql statement, and will its removal speed things up?



I reckon no and yes, but would appreciate the experts view!



Cheers,



Steve
Received on Thu Jul 17 2003 - 04:24:13 CDT












Original text of this message













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