What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 24242 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 an oracle function?
How to drop an existing view in oracle?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How many memory layers are in the oracle shared pool?
How can I create database in oracle?
How can I introduce multiple conditions in like operator?
What is the difference between a hot backup and a cold backup in oracle?
How to convert raw data type into text in oracle? Explain
How to create a new user account in oracle?
How to create a new table in your schema?
How do I call oracle stored procedures that take no parameters?
What is Reduced List of Values?
Explain what does a control file contain?
How to write date and time literals in oracle?
What do you mean by group by clause?
