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 are keys in sql?

944

Can we use views in stored procedure?

968

Explain the update statement in sql

916

Can primary key be changed?

869

What do you mean by dbms? What are its different types?

949

What is a loop in sql?

935

What are pl/sql packages?

1035

What are the steps for performance tuning.

1268

What is a common use of group by in sql?

995

What programs use sql?

941

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1026

What is data type in sql?

919

What is the difference between having clause and where clause?

1008

What is meaning of <> in sql?

1020

What is parameter substitution in sql?

976