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

How can we store rows in PL/SQL using array?

1266

how are mysql timestamps seen to a user? : Sql dba

1188

What is the use of nvl function?

1239

which tcp/ip port does sql server run on? : Sql dba

1077

How do you sort in sql?

1065

What does over partition by mean in sql?

1039

what is oracle database ? : Sql dba

1078

How do rank () and dense_rank () differ?

1104

when is the use of update_statistics command? : Sql dba

1094

Is sql an operating system?

1071

What is a data definition language?

1195

What are aggregate and scalar functions?

1081

How to pronounce postgresql?

1094

What schema means?

939

Is pl sql still used?

1016