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
Difference between table function and pipelined function?
Is sql a case sensitive language?
How to execute a stored procedure?
What is server name sql?
What is coalesce in sql?
What is the difference between syntax error and runtime error?
How do I remove sql plus from windows 10?
What is sql and its types?
Is inner join faster than left join?
what are the disadvantages of mysql? : Sql dba
Is left join faster than join?
What is a heap in sql?
What is union and union all keyword in sql and what are their differences?
What is sqlite format?
What is a primary key called that is made up of more than one field?