What is pragma restrict_reference in oracle 9i?When we use
this?Give me one realtime scenario?
- 4 Answers
- 10902 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
How to enter a new row into a table interactively?
Explain constraining triggers.
What happens to indexes if you drop a table?
How to return top 5 rows in oracle?
How to pass parameters to procedures?
What is an index associated with a constraint?
What is flashback in Oracle?
Explain cascading triggers.
Is oracle a relational database?
What are set operators?
Please explain joins in oracle?
Can we create trigger on materialized view in oracle?
How to get last row id?
Why do we use coalesce function in oracle?
Explain joins in oracle?
