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
- 11803 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
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What is java oracle used for?
How to write a query with a left outer join in oracle?
How to work with data objects interactively?
Where is the export dump file located?
How to assign query results to variables?
Explain the use of record option in exp command.
How to create tables for odbc connection testing?
What is merge in oracle?
How to rename a tablespace in oracle?
what is a Nested Loop join?
What is different types of joins?
Can select statements be used on views in oracle?
Why do we need integrity constraints in a database?
How to see free space of each tablespace?
