What is pragma restrict_reference in oracle 9i?When we use
this?Give me one realtime scenario?
- 4 Answers
- 10903 Views
- Microsoft, Wipro, I also Faced
- E-Mail Answers
Answer Posted / raphael fernandes
pragma restrict_reference is used to associate a user
defined exception to an oracle error. Whenever the
associated error occurs in the pl/sql code, the exception
is raised implicitly by Oracle.
| Is This Answer Correct ? | 3 Yes | 65 No |
Post New Answer View All Answers
What is oracle update statement with inner join ?
What happens to the current transaction if the session is ended?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to display employee records who gets more salary than the average salary in the department?
Compare and contrast between sql and sql server and explain its various functions?
Explain what are the different type of segments?
Where are the settings stored for each instance in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is enter substitution variable in oracle?
How to create a server parameter file?
Is there a function to split a string in plsql?
What is oracle analytical function?
How can you use check constraints for self referential integrity?
Explain what are clusters?
What is SQL Tuning Advisor in Oracle?
