what is difference between procedure and function
- 10 Answers
- 14422 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 are different types of keys?
how to use like conditions? : Sql dba
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Is null operator in sql?
What are the two types of exceptions.
what is innodb? : Sql dba
Is it possible to link two groups inside a cross products after the cross products group has been created?
How do you explain an index number?
Is microsoft sql free?
What is an ndf file?
What is the life of an sql statement?
What are the features of pl sql?
How do you remove duplicates without using distinct in sql?
how to enter characters as hex numbers? : Sql dba
What are the properties of a transaction?
