what is the structure of plsql block

DECLARE
             Variable Declaration
              Cursor Declaration 
              User Defined Exception
IS
BEGIN
         Executable Statement
EXCEPTION
        Exception Handling. Action to perform when error occurs. 
END;

Declare Section is optional. Variable and Cursor declaration is defined in declare section.
Executable Statement is defined in Begin Section.
Exception Section is the section where exception can be handled. This is an optional section

No comments:

Post a Comment