What are the various predefined exceptions?

PL/SQL - Interview Questions

Predefined exceptions are internally defined exceptions that occur during the execution of a program. For example, PL/SQL raises NO_DATA_FOUND when there are no rows returned upon a select operation, and if more than one row is returned using a select statement, TOO_MANY_ROWS error is generated. Some more examples :

* COLLECTION_IS_NULL : when a collection is null

* CURSOR_ALREADY_OPEN : When a cursor is already open

* LOGIN_DENIED : When login is incorrect or permission is not there