Interested to Buy Any Domain ? << Click Here >> for more details...
What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 26701 Views
- CA, Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / guru
stored procedure : It is Pre Compiled Code(PCode) it is stored
in Database. we can reuse without compile.
Function: It need compile whenever it will run.
| Is This Answer Correct ? | 15 Yes | 4 No |
Post New Answer View All Answers
What is the best way to do multi-row insert in oracle?
How to rename an existing table?
What is the use of aggregate functions in oracle?
What are advantages of dateset in datastage?
Which is better Oracle or MS SQL? Why?
How can I get column names from a table in oracle?
How to get the Installed Oracle Version Information ?
How to filter out duplications in the returning rows using oracle?
How view is different from a table?
How to define an anonymous procedure without variables?
Difference between hot backup vs. Cold backup?
can u plz provide me oca sql dumps please i need them
How to unlock the sample user account in oracle?
How to recover a dropped table in oracle?
Can a formula column referred to columns in higher group ?
