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

Why do you partition data?

1019

What is rename command in sql?

1035

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

1001

Why is the cursor important?

1043

what is sql in mysql? : Sql dba

1192

What is use of term?

1068

what are the properties and different types of sub-queries? : Sql dba

1034

What is the use of partition by in sql?

994

What is trigger with example?

1099

How do I run a sql query in pgadmin 4?

961

What is the cause of mutating table error and how can we solve it?

1049

How do you know if a relationship is 2nf?

944

What are keys in sql?

999

What is indexing in sql and its types?

1080

How to disable a trigger name update_salary?

1266