1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is Pragma EXECPTION_INIT ? Explain the usage ?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is Pragma EXECPTION_INIT ? Explain the usage ?..

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

What is Pragma EXECPTION_INIT ? Explain the usage ?..

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

Post New Answer

More SQL PLSQL Interview Questions

what is the difference between to_char and to_date functions?

10 Answers   Infosys,

What type of database is sql?

0 Answers  

What are the query optimization techniques?

0 Answers  

What is a scalar value in sql?

0 Answers  

Which sql statement is used to return only different values?

0 Answers  




What are keys in sql?

0 Answers  

what is the difference between truncate and delete statement? : Transact sql

0 Answers  

what is column? : Sql dba

0 Answers  

How is data stored in sql?

0 Answers  

Which query operators in sql is used for pattern matching?

0 Answers  

How many databases can sql express handle?

0 Answers  

What are sql ddl commands?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories