Function purity

What is function purity level and why we need it in PL/SQL function?

Questions by manju_kambar   answers by manju_kambar

Showing Answers 1 - 1 of 1 Answers

chaitanya

  • Sep 19th, 2014
 

Any function called from an sql query will have certain side effects on database state and package variables..these side effects are classified as purity levels. there are different purity levels like 1. read no database package state 2. write no database package state e.t.c

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions