What is pragma restrict_reference in oracle 9i?When we use
this?Give me one realtime scenario?
- 4 Answers
- 10274 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
Explain the use of constraints option in exp command.
What are the attributes of the cursor?
How to join two tables in a single query using oracle?
Can we write dml statement in function in oracle?
How to enter a new row into a table interactively?
How to delete all rows a table in oracle?
 What are the oracle DML commands possible through an update strategy?
What is a proxy class?
What is a package in oracle?
Explain rename?
Give syntax for SQL and ORACLE joins.
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to create id with auto_increment on oracle?
How to generate query output in html format?
What are the different types of trigger and explain its various uses and functions?
