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

Is sql scripting language?

991

How many functions are there in sql?

968

Are pl sql variables case sensitive?

1005

what are date and time data types in mysql? : Sql dba

930

What is normalization? How many normalization forms are there?

1022

Can we call dml statement in function?

989

what is the difference between delete and truncate commands? : Sql dba

1007

Does varchar need length?

944

What is execution plan in sql?

990

What are sql commands?

944

Why do we need a foreign key?

1030

How do I order columns in sql?

922

What are the two virtual tables available at the time of database trigger execution?

1167

Is a foreign key always unique?

895

Explain exception handling in pl/sql?

997