How to handle errors in PL/SQL?

Question

Q. How to handle errors in PL/SQL?

Answer 1

In PL/SQL, an error condition is called an exception and PL/SQL errors are handled using the EXCEPTION block. The syntax for handling exceptions is written below:
DECLARE
...
BEGIN
...
EXCEPTION
WHEN exception1 THEN
...
WHEN exception2 THEN
...
WHEN others THEN
...
END;