Home » SQL & PL/SQL » SQL & PL/SQL » purity level of a Function
purity level of a Function [message #10003] Sat, 20 December 2003 00:46 Go to next message
resy
Messages: 86
Registered: December 2003
Member
hi,

What is a functions "purity level" and what are the conditions for meeting that purity level?

thanx

Report message to a moderator

Re: purity level of a Function [message #10004 is a reply to message #10003] Sat, 20 December 2003 10:59 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
Senior Member
Here is a link to a section of the 9i PL/SQL User's Guide and Reference in the Oracle on-line documentation regarding the usage of pragma restrict_references to check the "purity" of a function, that is whether it writes to or reads from a database or package state.

Report message to a moderator

Re: purity level of a Function [message #10619 is a reply to message #10003] Tue, 03 February 2004 23:31 Go to previous messageGo to next message
Nabarun Sengupta
Messages: 2
Registered: January 2004
Junior Member
Prior to Oracle8i Release 8.1, it was necessary to assert the purity level of a packaged procedure or function when using it directly or indirectly in a SQL statement. Beginning with Oracle8i Release 8.1, the PL/SQL runtime engine determines a program's purity level automatically if no assertion exists.
The RESTRICT_REFERENCES pragma asserts a purity level

Report message to a moderator

Re: purity level of a Function [message #11025 is a reply to message #10619] Mon, 01 March 2004 18:56 Go to previous message
kamala
Messages: 3
Registered: January 2002
Junior Member
kindly answer all the que given below to my mailId

1) what is function purity level
2) what is inline view
3) what is inline query r scaler query
4) what is autonomus transaction and where is it used.
5) if u use single row function in where class ..will it index r not.
6) what is stastical function
7) what is propagation exception? how is used.
8) what is sequence ? what r the advantages of sequence? what is cache in sequence?
9) what is external table
10) what is new in 9i?
11) what is merger insert and bulk insert?
12) what is loader?
13) what is synonym? suppose u alter the table by adding 2 columns after creating the synonymn what would the stauts of synonym
14) what is profile?
15) how will find the duplicate record and how will u delete the duplicate record?
16) what r different kind of rights
17) what is the difference between grant all rights and dba rights
18) what is sub query and what is corralted subquery
19) how will write batch program in plsql?
20) what is dynamic sql?
21) what is ref cursor? how is it used?
22) what is execute immed?
23) how will u write ddl statment in a procedure?
24) can we ddl statment in triggers?
25) what are the basic grants to be given when a new user is created?
26)What is PRAGMA?
27)What is Dynamic SQL? What is difference between Native Dynamic SQL and DBMS_SQL?
28)What is Indexing? What are different kinds of Indexes?
29)What is PCTFREE and PCTUSED?
30)What is the difference between compiled and uncompiled version of Procedure or Function?
31)What are anonymous PL/SQL blocks?
32)What is TK Prof?
33)What is materialized view?
34)What is the use of CUBE and GROUPING function?
35)What is REF Cursor?

Report message to a moderator

Previous Topic: Package javax.servlet.http not found in import
Next Topic: Create Database Scripts
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 09:54:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.