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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are database links used for?

586


Can we use delete in merge statement?

507


What are the different ddl commands in sql?

572


How delete a row in sql?

526


what is a composite key ? : Sql dba

586






What are data types in pl sql?

548


What is asqueryable?

523


What is online transaction processing (oltp)?

598


Why join is faster than subquery?

592


Why do we need a foreign key?

540


Where not exists in sql?

499


What do you mean by field in sql?

525


How do I trace sql profiler?

487


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

537


What is a function in oracle pl sql?

529