what is difference between procedure and function
Answer Posted / aditi yadav
in addition to above answers -
1. Functions can be called inside procedure but procedure cannot be called inside functons.
2. Functions compiled every time when we call them whereas procedure compiles only once & can be called again and again without being compiled.
3. we can user functions in select statement but cannot use procedure.
4. Inside function we cannot user DML commands but inside procedures we can use DML commands.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between pl and sql?
Can we use views in stored procedure?
What will you get by the cursor attribute sql%found?
What does data normalization mean?
Does sql use python?
Differentiate between pl/sql and sql?
What is set transaction?
How do I view stored procedures?
What is the difference between instead of trigger and after trigger?
Why is pl sql used?
What company owns postgresql?
How to avoid using cursors?
How many functions are there in sql?
what is error ora-03113: end-of-file on communication channel?
What are the rules to be applied to nulls whilst doing comparisons?