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

What is sql scripting?

1048

Which join is default?

905

how to install mysql? : Sql dba

1057

Write the command to remove all players named sachin from the players table.

1129

what are sequences

1662

Are sql connections encrypted?

967

What are triggers and its uses?

1006

What is difference sql and mysql?

947

What is an exception in PL/SQL? What are the two types of exceptions?

1212

Why is sharding used?

959

Explain raise_application_error.

1053

What are the advantages of stored procedure?

957

What is before trigger?

951

What is the trigger in sql?

911

What is nvarchar in sql?

890