What Are The Components Of A Pl/sql Block?

1.	What Are The Components Of A Pl/sql Block?
Answer» A set of related declarations and PROCEDURAL statements is called block. DECLARE -- declaration section BEGIN -- executable statements -- main section EXCEPTION -- handling possible EXCEPTIONS -- occuring in the main section END; A set of related declarations and procedural statements is called block. DECLARE -- declaration section BEGIN -- executable statements -- main section EXCEPTION -- handling possible exceptions -- occuring in the main section END;

Answer»

A set of related declarations and PROCEDURAL statements is called block.

DECLARE -- declaration section

BEGIN -- executable statements -- main section

EXCEPTION -- handling possible EXCEPTIONS -- occuring in the main section END;

A set of related declarations and procedural statements is called block.

DECLARE -- declaration section

BEGIN -- executable statements -- main section

EXCEPTION -- handling possible exceptions -- occuring in the main section END;

Discussion