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
What is proxy method?
How to use "startup" command to start default instance?
How to return top 5 rows in oracle?
What is redo log?
can u plz provide me oca sql dumps please i need them
Explain oracle insert into command?
How to write text literals in oracle?
What are the different types of failures that occur in Oracle database?
How to define default values for formal parameters?
What is a read only transaction in oracle?
what is the use of system.effective.date variable in oracle?
What is background process in Oracle?
What are the oracle built-in data types?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is the quickest way to export a table to a flat file?