Re: deterministic function

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 27 Nov 2002 20:16:47 -0000
Message-ID: <as39ea$491$1$830fa79f@news.demon.co.uk>

Whilst we are on this topic - has anyone every managed to prove that a deterministic function actually DOES anything special for Oracle ?

In principle, if Oracle can avoid calling the function because it has recently called it with the same input, it is supposed to re-use the output: but I've not yet managed to build an experiment where I can see this happening, even under 9.2

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____Denver_______December 2/4
____England______January 21/23


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Daud wrote in message ...


>daud11_at_hotmail.com (Daud) wrote in message

news:<f0bf3cc3.0211260110.4d10401f_at_posting.google.com>...


>> Hi

>>

>> Is it possible to declare a function as DETERMINISTIC inside a

package?


>> I tried but got an error. Works fine in a standalone function.

>> I searched this newgroups but did not find the answer. Anybody

knows?


>>

>> rgds

>> Daud

>

>I got it. Only declare in package spec...not in package body like you

guys said.


>It works even though it is a bit odd.

>

>thanks

>Daud

Received on Wed Nov 27 2002 - 14:16:47 CST