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 are the original export and import utilities?

793


Describe varray?

858


What is meant by an index?

846


Whether any commands are used for months calculation? If so, what are they?

866


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2111


What are the types of trigger in oracle?

782


How to add another datafile to a tablespace?

838


How to install oracle database 10g xe?

798


How many categories of data types?

777


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1881


What are the varoius components of physical database structure of oracle database?

779


How to update values in a table in oracle?

791


Is java required for oracle client?

759


Why is oracle database so popular?

796


Explain about functional dependency and its relation with table design?

801