Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the basic structure of PL/SQL ?

Answer Posted / shekharjchandra

The basic structure of PL/SQL is

1. Header Section
2. Declaration Section
3. Executable Section
4. Exception Section

Eg:-

<<This_is_Header>>
DECLARE
a NUMBER ;
BEGIN
-- Code goes here
NULL;
EXCEPTION
WHEN OTHERS THEN
NULL ;
END ;

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the the update statement in sql?

1030


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1065


How to Execute a Package in PL/SQL.?

1194


what is sub-query? : Transact sql

1095


What is fmtonly in sql?

1077


What is an escape character in sql?

1020


What is nosql example?

1028


What is rownum and rowid?

1028


What is a natural join?

1062


What is pivot query?

1065


What is a trigger in sql?

1200


what is the difference between a web-garden and a web-farm? : Sql dba

1078


What is procedure explain with program?

1013


What is orm in sql?

1041


What is the clause we need to add in function body to return variable?

1009