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
What is connection pool in oracle?
Explain the function of optimizer in oracle?
What are the types of trigger in oracle?
How to do paging with oracle?
Does oracle charge for java?
what is the difference between functional dependecy and multilevel dependency?
What do you mean by a database transaction & what all tcl statements are available in oracle?
Is the After report trigger fired if the report execution fails ?
What is a sub query? Describe its types?
How to pass parameters to procedures?
what are the advantages of running a database in archive log mode?
How to write date and time interval literals in oracle?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
Explain what are synonyms used for?
State the difference between a primary key and foreign key?