Exception Handle « PL SQL « Oracle PL / SQL

1.Check exception type
2.Deal with multiple exception branches
3.when other exceptions then
4.Handle update exception
5.declaration exception
6.handle exception of duplicate value on index
7.when other then not user-defined exception
9.Different Values of SQLCODE and SQLERRM

10.The OTHERS Exception Handler
11.Error-handling features of PL/SQL: log exception
12.PLS-483 error: Duplicate Handlers
13.NO_DATA_FOUND exception.
14.The scope of exceptions.
15.Sub block in exception section
16.Catch all exceptions
17.Catch user-defined exception
18.Check zero divide exception
19.Combines declaring an EXCEPTION variable
20.Insert error message to a table in exception handler
21.Mapping a user-defined error code to an EXCEPTION variable
22.This script demonstrates the EXCEPTION_INIT pragma.
23.Error Handling Call
24.Raise exception in if statement