What are pl/sql exceptions? Tell me any three.



What are pl/sql exceptions? Tell me any three...

Answer / kiran r

An Exception is error handling part when ever error occurs exception raises.
Exceptions are classified as
1. Predefined Exception
2.User defined exception
some of predefined Exceptions are:
NO DATA FOUND, TOO MANY ROWS, CURSOR ALREADY OPEN, INVALID CURSOR, INVALID NUMBER, ZERO DIVIDED

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Explain the uses of control file.

0 Answers  


explain the difference between myisam static and myisam dynamic. : Sql dba

0 Answers  


Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

0 Answers  


Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

3 Answers   eBay,


What is use of trigger?

0 Answers  






Explain what is dbms?

0 Answers  


Can we insert data in view?

0 Answers  


display your age in months?

2 Answers  


What are the PL/SQL Statements used in cursor processing ?

4 Answers  


what is a database lock ? : Sql dba

0 Answers  


Why truncate is faster than delete?

0 Answers  


How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

0 Answers   MCN Solutions,


Categories