what is the differnce between procedure and function?
in both dml operations can work and in procedure through out
parameter you can return value ,then what is the differce?
Answer Posted / rajesh venati
1. Procedures are used to perform a particular task.
2. Procedures may or may not return a value, if u want
return a value though the OUT parameter it is possible. It
doesn't contain any RETURN key word.
3. Procedures are not valid in SELECT statement.
1. Functions are used for computation purpose.
2. Function must and should be return a value.
3. We can execute function in a SELECT statement.
-- If u use OUT or IN OUT parameters or perform any DML
operations on functions it is not valid in SELECT statement.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what is the difference between undefined value and null value? : Sql dba
What is clustered index in sql?
What is keys and its types?
Is ms sql is free?
What is the life of an sql statement?
what are the type of locks ? : Sql dba
What is sql and its types?
What is the difference between nested table and varray?
Explain mutating table error.
what is the functionality of the function htmlentities? : Sql dba
Which sql most popular?
Are views faster than queries?
Explain the difference between sql and mysql.
How do you change a value in sql?
What is query execution plan in sql?