GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Oracle  >  PL/SQL
Go To First  |  Previous Question  |  Next Question 
 PL/SQL  |  Question 2 of 236    Print  
What is the basic structure of PL/SQL ?
 
PL/SQL  uses  block  structure  as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.



  
Total Answers and Comments: 6 Last Update: February 16, 2008   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
October 10, 2005 12:06:23   #1  
StoneColdSteveAustin Member Since: October 2005   Contribution: 2    

RE: What is the basic structure of PL/SQL ?...

 

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.


 
Is this answer useful? Yes | No
November 21, 2005 02:00:23   #2  
ashish        

RE: What is the basic structure of PL/SQL ?...

DECLARE

...........

BEGIN

...........

EXCEPTION

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

END;


 
Is this answer useful? Yes | No
December 06, 2005 03:59:16   #3  
Jayakumar M        

RE: What is the basic structure of PL/SQL ?...

Declare [ Optional Section ]

Begin

Exception [ Optional Section ]

End;


 
Is this answer useful? Yes | No
June 23, 2007 00:45:03   #4  
ramesh_resides Member Since: March 2007   Contribution: 4    

RE: What is the basic structure of PL/SQL ?...
Declare (optional)

Begin

Exception (optional)

End

 
Is this answer useful? Yes | No
October 05, 2007 17:01:33   #5  
Me        

RE: What is the basic structure of PL/SQL ?...
Declaration
Begin
Exception Handling
End

 
Is this answer useful? Yes | No
February 16, 2008 15:32:47   #6  
g_sidhu Member Since: August 2007   Contribution: 122    

RE: What is the basic structure of PL/SQL ?
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).
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape