Re: dbinfo("sqlca.sqlerrd2")

Posted in 2003

Mark D. Stock — Tue, 07 Oct 2003 09:12:16 — source: IIUG Forums & Mailing Lists

preetinder .... wrote: > You can use nvl(min(nvl(colname,defvalue)),defval2) , this way you can > put ur defvalue to a value which is never used in ur application and > then check for this and can find out from defval2 if it did not have any > rows. Why, when you can simply check for NULL? Choosing a value that is not used is also an interesting exercise. The NVL function adds a large overhead in terms of performance. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+