MONALI

• Oct 2nd, 2006

 

PL/SQL IS A BLOCK STRUCTURE LANGUAGE.IT HAS THREE MAIN BLOCK AND

AN OPTIONAL BLOCK.THESE ARE DECLARE,EXECUTE,EXCENTION(OPTIONAL)

,END.

satish.m.v

 Profile Answers by satish.m.v 

• May 21st, 2007

 

the components of a pl/sql blocks
DECLARE
--------     (OPTIONAL)
-------
--------
BEGIN  (MANDATORY)
---------
----------
EXCEPTION  (OPTIONAL)
------------
------------
END;  (MANDATORY)

Rajendra

• Aug 31st, 2007

 

What is the difference between rowtype and %type?

g_sidhu

 Profile 

• Feb 16th, 2008

 

A PL/SQL block consists of up to three sections: declarative (optional), executable (required), and exception handling (optional).

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 14th, 2008

 

All has given the right answer and I am repeating the same.
There are the three component of PL/SQL program block
1) Declarative( Where you can decalre the variable which would be used as a part of exceution using DECLARE statement).
2) Exceution( Part of program which would exceute and will retrive the output)
   we need to start with BEGIN statement. this is the mandatory part of PL/SQL block.
others are optional can use based on requirement.

3) Exception: if we want to get result while program thrwoing any system or user defined error.

DECLARE
varaible declaration;
begin
eexceution;
exception
 exceptional part;
end;
/