Purity level of a function can be checked usingA. PRAGMA EXCEPTION_INIT.B. PRAGMA RESTRICT REFERENCESC. DBMS_OUTPUT.D. DBMS_SQL.

  • Interview Candidate
  • 4
  • 2183

Showing Answers 1 - 4 of 4 Answers

kehri_anurag

  • Jan 12th, 2006
 

When any function doing the task in addition to returning the value then it is called as a side effect .A function having the side effect is poor programming practice.

The extent of side effect is mesure by purity level. To minimize the side effect the rule is imposed on function,Using the PRAGMA RESTRICT_REFERENCES.

Syntax is Pragma Restrict_reference(Function_name,Restriction);

Restriction can be RNDS,RNPS,WNDS,WNPS or DEFAULT.

  Was this answer useful?  Yes