What is pragma restrict_reference in oracle 9i?When we use
this?Give me one realtime scenario?
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
Define oracle database
Differentiate between translate and replace?
What happens if you set the sga too low in oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is meant by raw datatype?
what is Single Byte Overhead...?
What is the relationship among database, tablespace and data file?
What is a relational database management system?
How do I recompile a procedure in oracle?
How to define a procedure inside another procedure?
Explain user account with reference to oracle.
What are the uses of synonyms?
Explain the use of rows option in exp command.
What are the different editions of oracle?
Give syntax for SQL and ORACLE joins.