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 sql statement is used to delete data from a database?
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
What is secondary key?
Is it possible to update views?
what are %TYPE and %ROWTYPE? what is the difference?
7 Answers ICICI, Saama Tech, Sail,
what are the differences between require and include, include_once and require_once? : Sql dba
How will we see framework of a table?
What is query syntax?
What do you understand by pl/sql cursors?
Delete the emps whose salaries are lowest sals of their own dept.
What is on delete set null?
If we have n no of columns in a table, can we add new column in that table with not null constraint?
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)