dbTalk Databases Forums  

Code review... gurus required!

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Code review... gurus required! in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Steve Holdoway
 
Posts: n/a

Default Code review... gurus required! - 07-17-2003 , 04:24 AM






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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.