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

Home -> Community -> Usenet -> c.d.o.tools -> Performance when own functions are used

Performance when own functions are used

From: Nicolas Bronke <newsgroup_at_trinity.de>
Date: 2000/09/20
Message-ID: <8qa92k$iaq$10$1@news.t-online.com>#1/1

Short question,

If I use a stored function as an replacement for an oracle function like

CREATE OR REPLACE FUNCTION SP_SIGN (nBetrag IN NUMBER) return integer
as
begin

   return SIGN(NBETRAG);
end SP_SIGN ;
/

Does that decrease the performance or not? Regards

GrĂ¼sse
Nicolas Received on Wed Sep 20 2000 - 00:00:00 CDT

Original text of this message

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