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 happens if you lost a data file?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is parameterized cursor in oracle?
How different is ms access and oracle?
How to assign a table row to a record variable?
what are bitmap indexes? How does they work?
What is Data Dictionary Cache in Oracle?
What is the best way to do multi-row insert in oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
What is the disadvantage of User defind function?
What is an Oracle Instance?
Explain the difference between replace() and translate() functions in oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
What operating systems are supported by oracle database 10g xe?
Explain alias?