What is Pragma EXECPTION_INIT ? Explain the usage ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / harish
Oracle have some builtin errors but they have only error
code not the error name user can define this builtin errors
by using Pragma EXECPTION_INIT
| Is This Answer Correct ? | 1 Yes | 1 No |
Which are sql * plus commands?
What is sql indexing?
What is pseudo column ?
what are all the different types of indexes? : Sql dba
What is Referential Integrity?
Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.
what is sub-query? : Transact sql
How do I restart sql?
Is sql sequential or random?
What are the components of a PL/SQL block ?
What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?
How does cross join work in sql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)