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

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2015


Mention what pl/sql package consists of?

998


What is sql injection owasp?

1062


What is trigger and types?

1025


what is a table in a database ? : Sql dba

1040


what are the 'mysql' command line arguments? : Sql dba

1138


What are the sql aggregate functions?

1131


How to raise user-defined exception with custom sqlerrm ?

1129


what are the 'mysql' command line options? : Sql dba

1072


Can you have a foreign key without a primary key?

955


Which are the different case manipulation functions in sql?

1023


When is the update_statistics command used?

1116


What is difference between primary and secondary key?

1027


What is sql basics?

1041


In a distributed database system, can we execute two queries simultaneously?

1092