Function always return a single value Procedure may or may not return a va

what is difference between procedure and function

Question Posted / monalisa dalbehera

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

Please Help Members By Posting Answers For Below Questions

Can we use ddl statements in stored procedure sql server?

1006

How do you know if a relationship is 2nf?

942

How do we use distinct statement? What is its use?

1029

differentiate between float and double. : Sql dba

1054

Explain spool.

1176

What is oracle and pl sql?

1118

Is ms sql is free?

1020

How to execute a stored procedure?

1085

what is the difference between a having clause and a where clause? : Sql dba

1081

What is meaning of <> in sql?

1066

How to avoid using cursors?

1118

How can one get sql*loader to commit only at the end of the load file? : aql loader

1059

Why sql query is slow?

988

How can triggers be used for the table auditing?

1068

What is rownum and rowid?

1030