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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What types of commands can be executed in sql*plus?

761


What are triggers in sql?

749


What is trigger explain with example?

749


what are string data types? : Sql dba

697


Is sql an operating system?

719






Write a sql query to get the third highest salary of an employee from employee_table?

828


What does over partition by mean in sql?

707


How do I write a sql query in pgadmin 4?

712


Which nosql database is best?

679


What is dynamic sql in pl sql?

707


Enlist the data types that can be used in pl/sql?

743


what is the difference between sql and t-sql? : Transact sql

804


How do you identify a primary key?

811


What is normalisation in sql?

769


What is a full join?

705