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 -> Re: testing an overloaded function

Re: testing an overloaded function

From: Jan <janik_at_pobox.sk>
Date: 6 Dec 2001 22:47:09 -0800
Message-ID: <81511301.0112062247.180a8913@posting.google.com>


It`s difficult to advice, if you don`t explain your goal more deeply.

But for the original question:

  1. - SELECT COUNT(*) - it will go trough all chosen rows (you can have 100 of such rows), but you need only 2 => waste of time, worse performance.

I use EXCEPTION - as you wrote or CURSORs - depends on its purpose

Jan Received on Fri Dec 07 2001 - 00:47:09 CST

Original text of this message

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