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 is interval partition?

546


What has stored procedures in sql and how we can use it?

570


what are the differences between char and nchar? : Sql dba

595


List the various privileges that a user can grant to another user?

585


What is sqlite used for?

533






what are myisam tables? : Sql dba

552


How to select 10 records from a table?

650


which operator is used in query for pattern matching? : Sql dba

547


How do I run a sql query in pgadmin 4?

548


what is a composite key ? : Sql dba

605


Is there a way to automate sql execution from the command-line, batch job or shell script?

557


What are triggers and its uses?

595


Is sql procedural language?

554


what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

524


how to use case expression? : Sql dba

553