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 schema in sql?

887

Explain spool.

1114

what is a view? : Sql dba

1030

what is the difference between primary key and unique key? : Sql dba

972

What are % type and % rowtype?

983

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

969

What are functions in sql?

906

How do I view stored procedures?

918

How do we accept inputs from user during runtime?

993

What is varchar example?

975

What is data profiling in sql?

1021

what are integrity rules?

966

How do I get sql certification?

926

What are the various restrictions imposed on view in terms of dml?

911

Why do we need view in sql?

934