StoneColdSteveAustin

 Profile Answers by StoneColdSteveAustin 

• Oct 10th, 2005

 

 

A PL/SQL block has three parts:

a declarative part,

an executable part,

and an exception-handling part.

 

 

First comes the declarative part, in which items can

be declared. Once declared, items can be manipulated in the executable part.

Exceptions raised during execution can be dealt with in the exception-handling

part.

ashish

• Nov 21st, 2005

 

DECLARE

...........

BEGIN

...........

EXCEPTION

............

END;

Jayakumar M

• Dec 6th, 2005

 

Declare [ Optional Section ]

Begin

Exception [ Optional Section ]

End;

ramesh_resides

 Profile Answers by ramesh_resides 

• Jun 23rd, 2007

 

Declare (optional)

Begin

Exception (optional)

End

Me

• Oct 5th, 2007

 

Declaration
Begin
Exception Handling
End

g_sidhu

 Profile 

• Feb 16th, 2008

 

PL/SQL is a block-structured language, meaning that programs can be divided into logical blocks. A PL/SQL block consists of up to three sections: declarative (optional), executable (required), and exception handling (optional).