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

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

Answer Question  Select Best Answer

What is recursive function, explain with example?

Vishant Gupta

• Oct 11th, 2014

It is function that calls itself to implement some repetitive task

VIVEK

• Sep 24th, 2014

Function is calling the same function

Answer Question  Select Best Answer