What is pragma restrict_reference in oracle 9i?When we use
this?Give me one realtime scenario?
- 4 Answers
- 10230 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
What is the difference between "as" and "is" in an oracle stored procedure?
How to build data dictionary view an new database?
How to display row numbers with the records?
What do you understand by a database object? Can you list a few of them?
What is the difference between hot backup and cold backup in oracle?
What is an external table?
How to run the anonymous block again?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain coalesce function?
Explain implicit cursor.
How to turn on or off recycle bin for the instance?
How to define default values for formal parameters?
what is the use of system.effective.date variable in oracle?
How to loop through data rows in the implicit cursor?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
