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 time based sql injection?
How many types of functions are there in sql?
How can I change database name in sql?
what are integrity rules?
What is java sql connection?
Can ddl statements be used in pl/sql?
Is there any restriction on the use of union in embedded sql?
What is rownum?
What does the argument [or replace] do?
What are field types?
What view means?
Explain locks? : Transact sql
Where can I learn sql for free?
What is the difference between local variables and global variables?
Can we insert delete data in view?