Home » SQL & PL/SQL » SQL & PL/SQL » Difference between Deterministic functions and Function result cache in 11g (11gR2,Solaris)
Difference between Deterministic functions and Function result cache in 11g [message #569587] Tue, 30 October 2012 01:45 Go to next message
tigsav
Messages: 41
Registered: April 2012
Member
Hi Everybody ,
Can you explain the difference between Difference between Deterministic functions and Function result cache in 11g?

Regards,
tigsav
Re: Difference between Deterministic functions and Function result cache in 11g [message #569593 is a reply to message #569587] Tue, 30 October 2012 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A result cache function is a deterministic function; the opposite is not necessary true.

See Database PL/SQL Language Reference
Chapter 8 PL/SQL Subprograms
Section PL/SQL Function Result Cache
Especially paragraph Restrictions on Result-Cached Functions

Regards
Michel
Re: Difference between Deterministic functions and Function result cache in 11g [message #569594 is a reply to message #569587] Tue, 30 October 2012 02:26 Go to previous messageGo to next message
v.ram81
Messages: 50
Registered: April 2006
Location: pune
Member

Hi,

For PL/SQL Function Result Cache -

http://www.oracle.com/technetwork/issue-archive/2007/07-sep/o57plsql-088600.html

http://docs.oracle.com/cd/E11882_01/appdev.112/e10472/subprograms.htm#BABFHACJ

For DETERMINISTIC Function -

http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_function.htm#i2153260

Sorry.. Michel already provided links..

Regards,
Ram

[Updated on: Tue, 30 October 2012 02:27]

Report message to a moderator

Re: Difference between Deterministic functions and Function result cache in 11g [message #569596 is a reply to message #569594] Tue, 30 October 2012 02:36 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No need to be sorry, it is better to get the links twice (at the same time) than never. Smile

Regards
Michel
Re: Difference between Deterministic functions and Function result cache in 11g [message #569607 is a reply to message #569596] Tue, 30 October 2012 05:19 Go to previous message
tigsav
Messages: 41
Registered: April 2012
Member
Thanksd a lot Michel and Ram!!!!
Previous Topic: remove spaces by excluding double quotes from a string in sql
Next Topic: How to create a view
Goto Forum:
  


Current Time: Sat Sep 20 21:37:37 CDT 2014

Total time taken to generate the page: 0.07549 seconds