What is Pragma EXECPTION_INIT ? Explain the usage ?
Answer Posted / tulsi
The PRAGMA EXECPTION_INIT tells the complier to associate
an exception with an oracle error. To get an error message
of a specific oracle error.
e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error
number)
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
what are the differences among rownum, rank and dense_rank? : Sql dba
Which is better cte or subquery?
Does sql between include endpoints?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What is the most important ddl statements in sql are?
Show the cursor attributes of pl/sql.
How can you tell the difference between an index and a view?
How can you select unique records from a table?
what are the different type of normalization? : Sql dba
Is sql a backend?
What are the properties of a transaction?
What is faster join or subquery?
What is difference between hql and native sql?
Can we use ddl commands in pl sql?
What is sqlca in powerbuilder?