what are stored procedures?

Answer Posted / pushpa

stored procedures means containing a precompiled block of
code.
if we call stored procedures they need not compiled,only
execution takes place.
with this advantage ,work on database is less.

with these sps we can perform business logics.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by joins?

837


Explain the use of indexes option in imp command.

788


How to connect asp pages to oracle servers?

791


How to upsert (update or insert into a table)?

753


How to use values from other tables in update statements using oracle?

846


Explain about functional dependency and its relation with table design?

778


How to write a query with a left outer join in oracle?

833


What is using clause and give example?

815


Describe an oracle table?

801


In what script is snap$ created? In what script is the scott/tiger schema created?

2481


What is logical backup in oracle?

785


Please explain oracle left join with an example?

776


State and explain about oracle instance?

748


List out the difference between commit, rollback, and savepoint?

809


Is the After report trigger fired if the report execution fails ?

2701