Interested to Buy Any Domain ? << Click Here >> for more details...
What is pragma restrict_reference in oracle 9i?When we use
this?Give me one realtime scenario?
- 4 Answers
- 11804 Views
- Microsoft, Wipro, I also Faced
- E-Mail Answers
Answer Posted / bhaskar gouda
First of all ,it is a compiler directive,This is introduced
to avoid the side affect of the function in a package .it
comes in 4 flavors.RNDS,WNDS,RNPS,WNPS.
each out of the above 4 can be implemented against the
packaged function.
If you want the function not to alter the contents of any
database table than you can use WNDS.similarly if you want
the function not to read the contents of any database table
you can use RNDS.If you want the function not to alter any
variables within another package than you can use WNPS.If
you want the packaged function not to read the variables
within another package than you can use RNPS.
Thanks-Bhaskar Gouda
| Is This Answer Correct ? | 35 Yes | 2 No |
Post New Answer View All Answers
How to convert characters to times in oracle?
What is a nested table?
Write a trigger example in oracle?
What are the system predefined user roles?
How to sort output in descending order in oracle?
 What are the oracle DML commands possible through an update strategy?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to export your connection information to a file?
what are the advantages of running a database in archive log mode?
How to get the Installed Oracle Version Information ?
How many types of tables supported by oracle?
What is control file used for?
Where are the settings stored for each instance in oracle?
What is enter substitution variable in oracle?
How can we create the complete backup of data in the oracle.
