Saturday 26 May 2012

Give the block structure of an exception section within the PL/SQL code. | PL SQL

 The structure of an exception section within the PL/SQL code is given as follows:
DECLARE
PL/SQL code .....;
BEGIN
PL/SQL code .....;
EXCEPTION
WHEN exception1 then
PL/SQL code .....;
WHEN exception2 then
PL/SQL code .....;
WHEN OTHERS THEN
PL/SQL code .....;
END;