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
- 11683 Views
- Microsoft, Wipro, I also Faced
- E-Mail Answers
Answer Posted / m.nihar
The RESTRICT_REFERENCES pragma asserts that a user-defined subprogram does not read or write database tables or package variables.Subprograms that read or write database tables or package variables are difficult to optimize, because any invocation of the subprogram might produce different results or encounter errors.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an oracle cursor variable?
Explain the use of indexes option in exp command.
What do you understand by a database object?
What is data file?
What is the meaning of recursive hints in oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What are temporal data types in oracle?
What is analyze command used for?
What is a nvl function? How can it be used?
What is different types of joins?
Explain what are synonyms used for?
Can we save images in a database and if yes, how?
How to use subqueries with the exists operator in oracle?
What are the different pseudo commands? Explain in general?
How to use like conditions in oracle?
