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

Question Posted / amit kumar

1 Answers
1310 Views
I also Faced
E-Mail Answers

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

What is the default isolation level in sql server? : Transact sql

0 Answers

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers Fintellix,

Is oracel sql developer written in java?

0 Answers

How can we solve sql error: ora-00904: invalid identifier?

0 Answers

What is the difference between a subquery and a join?

0 Answers

Why is sql important?

0 Answers

How do you use join?

0 Answers

how to decrement dates by 1 in mysql? : Sql dba