Paramjeet singh

• Sep 15th, 2005

 

Component of PL/SQL Block are Begin,Declare(Mandatory),Exception,ENd.

Prakash Nandwana

• Sep 27th, 2005

 

The components of a PL/SQL are Declare,Begin , Exception , End.

Chandra Shekhar

• Oct 3rd, 2005

 

PL/SQL Block contains :

Declare : optional

Variable declaration

Begin  : Manadatory

Procedural statements.

Exception : Optional

any errors to be trapped

End :  Mandatory

So only begin and end keywords are required, as needed, to process a pl/sql block.

P.Ravi

• Nov 17th, 2005

 

A PL/SQL block is basically DECLARE -- Variable declaration sectionBEGIN -- set of statementsExceptions-- Exceptions Hanlders or set of statementsEnd;/

Yestha Bapna

• Aug 14th, 2007

 

[ DECLARE

 <local declarations> ]

BEGIN

 <procedural statement>
  <SQL>

[ EXCEPTION
 <exception handler(s)> ]

END;

nitingalande

 Profile Answers by nitingalande 

• Jan 13th, 2008

 

PL-SQL block has three main components
Declartion Section
Procedurial Statements Block
Exception/Error Handling Section

g_sidhu

 Profile 

• Feb 16th, 2008

 

A PL/SQL block consists of up to three sections:

declarative (optional),

executable (required),

and exception handling (optional).

Arvind209

 Profile Answers by Arvind209 

• Jun 29th, 2008

 

Component of PL/SQL Block are Begin(Optional), Declare(Mandatory), Exception(Optional), END(Mandatory).

prakashraj.v

 Profile Answers by prakashraj.v 

• Jul 14th, 2008

 

Component of PL/SQL Block are Declare(Optional), Begin(Mandatory), Exception(Optional), END(Mandatory).

saravanan

• Nov 29th, 2013

 

NIL

Kevin Korir

• Dec 10th, 2016

 

Declare: optional
Begin:mandatory-program logic of SQL&plsql statements
Exception: optional (error handling)
End:mandatory
(Forward slash / terminates)

vamsi

• Jun 7th, 2017

 

cursors
collections
procedures
functions
triggers