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 is sql in mysql? : Sql dba

1145


What are sql functions? Describe the different types of sql functions?

1079


Difference between table function and pipelined function?

984


What is not equal in sql?

1050


Do prepared statements prevent sql injection?

916


Does sql use python?

997


What are the different schemas objects that can be created using pl/sql?

986


What is crud diagram?

894


what are the differences between char and nchar? : Sql dba

1079


What is the purpose of design view?

969


What is dense_rank?

897


What are the different ways to optimize a sql query?

910


What is the use of function in sql?

1046


What is a database event trigger?

1107


What is the difference between delete and truncate statement in sql?

1027