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 different windows events activated at runtime ?

2408


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1701


What is snapshot is too old? Give and example for better understand.

1100


What is difference between cartesian join and cross join?

585


Differentiate between translate and replace?

625






What is a trigger and what are its types in oracle?

532


How to generate query output in html format?

563


How to write date and time literals in oracle?

555


what is port in oracle? how is it related to database application.

1438


Explain what are the different type of segments?

576


Explain the use of full option in exp command.

587


What are the different types of synonyms?

592


What is catalog in Oracle?

647


What is data block in Oracle?

615


How can I get column names from a table in oracle?

534