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 the difference between a query and a report?

966


How to add new employee details in an employee_details table with the following details

1085


What are the advantages of indexing?

980


What is coalesce in sql?

1051


What is the difference between microsoft sql and mysql?

958


What is a join query?

951


Does mysql_real_escape_string prevent sql injection?

944


Is pl sql better than sql?

1021


what are the types of join and explain each? : Sql dba

1035


Why is sql*loader direct path so fast?

1099


how to get help information from the server? : Sql dba

939


How can we find duplicate records in a table?

944


What are triggers and its types?

1055


What is the cause of mutating table error and how can we solve it?

1047


What operating systems are supported by oracle sql developer?

952