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
- 12010 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
Use of an integrity constraint is better to validate data. Explain
What are the predefined tablespaces in a database?
How to update values in a table in oracle?
How to delete a user account in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Explain the use of inctype option in exp command.
Is oracle a programming language?
How can you use check constraints for self referential integrity?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How to shutdown your 10g xe server?
Is rowid unique in oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to convert characters to dates in oracle?
What happens if you lost a data file?
Explain mutating triggers.
