Sign Up Login


  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

How do we tune the code?

2 Answers  

Is pl sql different from sql?

0 Answers  

What is the usage of sql functions?

0 Answers  

What are the advantages of VIEW?

5 Answers  

What is view? Can we update view

0 Answers  




Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

What is full join?

0 Answers  

How can we optimize a sql query?

0 Answers  

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

What is crud stand for?

0 Answers  

explain advantages of innodb over myisam. : Sql dba

0 Answers  

In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,

For more SQL PLSQL Interview Questions Click Here
Categories