function should always return only one value but procedure may return a va

function can return value ,procedure also return value through
out parameter then what is the difference?

Question Posted / damodharan

Answer Posted / damodharan

function should always return only one value
but procedure may return a value value it may one or more
than one value

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is the difference between clustered and non clustered index in sql? : Sql dba

1120

What is sql in oracle?

1055

What is the use of index in hive?

1000

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

959

What type of join is sql join?

975

What is dynamic sql in pl sql?

1028

what is not null constraint? : Sql dba

1023

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

1018

What do you understand by exception handling in pl/sql?

1030

How would you convert date into julian date format?

1000

What is partition by in sql?

1060

What is query optimization in sql?

979

what is the difference between union and union all? : Sql dba

1014

How do you update a sql procedure?

1019

Can we insert data in view?

953