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
How to install oracle odbc drivers?
What do you understand by database schema and what does it hold?
What is index in Oracle?
How to rename an existing table?
Explain the use of grant option in exp command.
 How to use an oracle sequence generator in a mapping?
How to convert characters to dates in oracle?
How to use select statement to count the number of rows in oracle?
What is tns name?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to view the data files in the current database?
What do you mean by merge in oracle and how can you merge two tables?
Can a formula column be obtained through a select statement ?