Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 8121 Views
- 3i Infotech, I also Faced
- E-Mail Answers
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
List different type of expressions with the example.
What is a temporal data type?
What is difference between left and right outer join?
What is the plv (pl/vision) package offers?
Can we group by two columns in sql?
How is indexing done in search engines?
What is the difference between delete and truncate commands?
What are packages in pl sql and also explain its advantages?
What is difference between stored procedures and application procedures?
What is sql exception?
What is a database trigger?
differentiate between float and double. : Sql dba
What are sql functions? Describe the different types of sql functions?
How to display the current date in sql?
What is the difference between nested table and varray?
