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 does select count (*) mean in sql?
Mention what plvcmt and plvrb does in pl/sql?
What are the various restrictions imposed on view in terms of dml?
What are the query optimization techniques?
Can a foreign key be a duplicate?
What is the left table in sql?
What is sqlca in db2?
What is difference between hql and sql?
What is recursive stored procedure?
What is memory optimized table?
Is it possible to create startup or shutdown trigger for on-schema?
What is a delimiter in sas?
What is query execution plan in sql?
How to run sql statements through the web interface?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?