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 nullCURSOR_ALREADY_OPEN : When a cursor is already openLOGIN_DENIED : When login is incorrect or permission is not there