what is difference between procedure and function

Answer Posted / monalisa dalbehera

Function always return a single value
Procedure may or may not return a value.
A procedure can return more than one value by using out
parameter.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rowid in sql?

676


What is database sql?

709


What are different types of keys?

737


What is before trigger?

735


What is offset and limit in sql?

744






What is vector point function?

770


How can I delete duplicate rows?

739


How to handle bulk data?

1052


What does cursor do in sql?

716


What is auto increment feature in sql?

819


Explain the types of joins in sql?

737


Is sql procedural language?

738


How do I find duplicates in sql?

690


What is basic structure of pl sql?

686


what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

732