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

what is query cache in mysql? : Sql dba

0 Answers  


Can we insert delete data in view?

0 Answers  


Which command is used to delete a trigger?

0 Answers  


Why are aggregate functions called so?

0 Answers  


How many aggregate functions are available there in sql?

0 Answers  






Is it possible to create the following trigger: before or after update trigger for each row?

0 Answers  


What is full form of rtm?

0 Answers  


What are pl/sql cursors?

0 Answers  


What is difference between rank () row_number () and dense_rank () in sql?

0 Answers  


What are the different tcl commands in sql?

0 Answers  


how to check server status with 'mysqladmin'? : Sql dba

0 Answers  


I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  


Categories