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 |
what is the difference between char and varchar data types? : Sql dba
What is the diffrence between IN and EXISTS.which one is faster.
how to rename an existing table in mysql? : Sql dba
How do you know if a relationship is 2nf?
How can analyze query after generating explain plan ?
Explain aggregate functions are available there in sql?
what is 'mysqladmin' in mysql? : Sql dba
Explain spool.
Is join same as left join?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is difference between nchar and nvarchar?
What is composite data type in pl sql?
Oracle (3259)
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)