Interested to Buy Any Domain ? << Click Here >> for more details...
What is Pragma EXECPTION_INIT ? Explain the usage ?
- 2 Answers
- 10003 Views
- I also Faced
- E-Mail Answers
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 |
How can you know that statistics should be updated?
What version is sql?
What is the benefit of foreign key?
How do I remove duplicates in two columns?
What does fetching a cursor do?
Can we relate two different tables from two different users in ORACLE,PL/SQL?
What is orm in sql?
What is difference sql and mysql?
How do you respond to dementia behavior?
Why join is faster than subquery?
How can we make an if statement within a select statement?
How do I run a script in sql developer?
-
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)
