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 advantages of Stored Procedures?

Answer Posted / roopesh kumar

The stored procedures are compiled pl/sql code block that
are stored in oracle's data dictonary as p-code. When we
have to use a perticular code block many times then we
should use procedure, function etc.

The use of procedure save time of execution of a block &
remove the need to write the code of a block every time.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different types of triggers?

1026


What is primary key and unique key?

1049


How does cross join work in sql?

956


Is it possible to update views?

916


Does pdo prevent sql injection?

884


What are two statement types in sql?

1031


Is like operator in sql case sensitive?

961


What is record variable?

923


What is blind sql injection?

990


Give the order of sql select?

1087


What is mdf ldf and ndf?

931


how to see the create table statement of an existing table? : Sql dba

946


What is the difference between a primary key and a clustered index?

930


What is execute immediate?

1004


What is the difference between sum and count in sql?

937