Explain some predefined exceptions.



Explain some predefined exceptions...

Answer / Sapna Arya

In PL/SQL, there are several predefined exceptions that can be raised to handle errors or unexpected conditions. Some examples include NO_DATA_FOUND (when a query does not return any rows), TOO_MANY_ROWS (when more than one row is returned from a function), and ZERO_DIVIDE (when division by zero occurs).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is the difference between delete and truncate commands?

1 Answers  


what are the different index configurations a table can have? : Sql dba

1 Answers  


what are the limitations of identity column? : Transact sql

1 Answers  


select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  


What is Referential Integrity?

3 Answers  


What is serial sql?

1 Answers  


Can we join same table in sql?

1 Answers  


What is t sql used for?

1 Answers  


What is an escape character in sql?

1 Answers  


What is recursive stored procedure?

1 Answers  


how to create a test table in your mysql server? : Sql dba

1 Answers  


What are two virtual tables available during database trigger execution ?

2 Answers  


Categories