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
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What are ddl statements in oracle?
How translate command is different from replace?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to set up autotrace for a user account?
How to convert character types to numeric types?
What is max rowid in oracle?
What are joins, explain all types of joins?
Explain mutating triggers.
Explain the features of oracle?
What is Data Dictionary Cache in Oracle?
Explain constraining triggers.
How to export data to a csv file?
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??
What is PL/SQL ?