| CAN ANYBODY PLS ANSWER THIS QUESTION [message #6238] |
Sat, 05 April 2003 02:31  |
ishita
Messages: 15
Registered: April 2003
|
Junior Member |
|
|
Q Drag the purity level simple in the left column to match its definition in the right column?
RNTS WNDS The function can not modify the database tables.
RNPS WNPS The function can not change the values of the
package variables.
The function can not query database tables.
The function can not reference the value of
public packaged variables.
Answer: Unknown
|
|
|
|
| Re: CAN ANYBODY PLS ANSWER THIS QUESTION [message #6241 is a reply to message #6238] |
Sat, 05 April 2003 03:11  |
 |
Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
Prior to Oracle 8i, it was required to used PRAGMA RESTRICT_REFERENCES to check the purity of packaged functions. Since 8i, this is now optional. By purity, it is meant that it does not violate any rules. Those rules are abbreviated as parameters of PRAGMA RESTIRCT_REFERENCES as follows:
WNDS = Writes no database state (does not modify database tables).
RNDS = Reads no database state (does not query database tables).
WNPS = Writes no package state (does not change the values of packaged variables).
RNPS = Reads no package state (does not reference the values of packaged variables).
Please click on the link below for additional information on the subject in the Oracle on-line documentation:
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
