not sure what you are really talking to but in general nvl is quite well optimized while I am a fan of use case expressions since they seem to be better performing than decodes.
Someone else want to wade in on this in case my understanding is no longer accurate? Rob On Jun 14, 5:41 am, kazim hooshmand <[email protected]> wrote: > sample code for decode function: > > count1>Decode(count2,NULL,0,count2) > > it will do the nvl() task as well as extra features for case, and make > the coding shorter > > thanks -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
