Interested to Buy Any Domain ? << Click Here >> for more details...
What are main difference between Stored Procedure and
Functions.
- 6 Answers
- 26914 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
How to Truncate Table in Oracle
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is data block in Oracle?
Can we call procedure inside function in oracle?
What are the set operators union, union all, minus & intersect meant to do?
Can we protect our pl/sql source code?
Is java required for oracle client?
What is the quickest way to export a table to a flat file?
How to assign values to variables?
What is SQL Tuning Advisor in Oracle?
How to name query output columns in oracle?
what is reindexing?
What are the different types of database objects?
Which is better Oracle or MS SQL? Why?
How to define a data field as not null?
