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 are the components of a PL/SQL block ?

Answer Posted / nishi

Declare section

---

declaring the variables

---

Begin section

---

executable statements

---

Exception section

---

exception handlers

---

end;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the purpose of %type and %rowtype data types?

928


What is pragma in pl sql?

1110


How do I find duplicates in a single column in sql?

1020


What is rownum?

980


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1001


How to read xml file in oracle pl sql?

913


what is the difference between char_length and length? : Sql dba

1044


what is 'mysqlcheck'? : Sql dba

1012


What are the disadvantages of not performing database normalization?

1164


how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

4014


How does postgresql compare to "nosql"?

1029


What is the difference between mdf and ndf files?

1119


Difference between truncate, delete and drop commands?

1082


What is pls integer?

1042


What is numeric function sql?

1059