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
- 11861 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 select an oracle system id (sid)?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is a proxy object?
How to create a new table by selecting rows from another table?
What privilege is needed for a user to create indexes in oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How to turn on or off recycle bin for the session?
What are the differences between blob and clob in oracle?
Can we use bind variables in oracle stored procedure?
How to loop through data rows in the implicit cursor?
Why we use bulk collect in oracle?
What is background process in Oracle?
What is the difference between pre-select and pre-query?
Can objects of the same schema reside in different tablespace?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
