What are advantages of Stored Procedures?

Answer Posted / greatasoft-mani.b

Stored Procedure's are precomplied one. When ever you call
a stored procedure it generate the result faster than
ordinay coding. The improve the performance of the
application i.e to reduce the time stored procedure's are
used

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a null value?

653


What pl/sql package consists of?

633


What is trigger and types?

560


What is memory optimized table?

571


Explain constraints in sql?

569






How can you load microsoft excel data into oracle? : aql loader

613


How do I run pl sql in sql developer?

624


How do I start pl sql?

491


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1554


What is parameter substitution in sql?

523


How do I make sql search faster?

552


Is grant a ddl statement?

449


What are triggers in sql?

578


What is form and report?

516


Which one is better subquery or joins?

553