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


Please Help Members By Posting Answers For Below Questions

What is background process in Oracle?

622


Explain about the analyze command in oracle?

575


How to assign a table row to a record variable?

575


What is a initialization parameter file in oracle?

575


How to define a variable to match a table column data type?

574






In oracle there is column command, how will you explain that?

543


How to delete a user account in oracle?

547


How to check the server version in oracle?

607


Explain the truncate in oracle?

543


What is query image?

575


How does oracle handle read consistency?

670


What privilege is needed for a user to query tables in another schema?

502


Why is oracle so popular?

556


What are the different pseudo commands? Explain in general?

537


What is the relation of a user account and a schema?

604