Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between procedure and function
- 10 Answers
- 16510 Views
- MCN Solutions, Wipro, I also Faced
- E-Mail Answers
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 datawarehouse? : Sql dba
What schema means?
what is data control language? : Sql dba
What does stand for in sql?
What are pl/sql cursors?
What is the purpose of my sql?
What are character functions?
what is text? : Sql dba
What is constant in pl sql?
Why is a trigger used?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What is a data manipulation language?
What is procedure explain with program?
What is a natural join?
What is difference between cursor and trigger?
