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
- 11674 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 use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is a tns service name?
Whats the benefit of dbms_stats over analyze?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How to sort output in descending order in oracle?
What do you understand by a database object? Can you list a few of them?
Explain the blob datatype?
How to write numeric literals in oracle?
Is oracle a programming language?
Explain an integrity constrains?
Whether any commands are used for months calculation? If so, what are they?
State and explain about oracle instance?
How to list all user accounts in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to create an initialization parameter file?
