what is difference between procedure and function

Answer Posted / shyam katwal

The only difference between procedure and function is:
Function returns a value
whereas
Procedure does not return a value

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is trigger types in sql?

627


What is online transaction processing (oltp)?

684


Is left join faster than inner join?

732


How many types of indexes are there in sql?

621


What does select count (*) mean in sql?

633






i have some prob lem to tell me about my self in interview first round ...

1793


In pl/sql, what is bulk binding, and when/how would it help performance?

629


How do I run a program in pl sql?

590


What do you understand by case manipulation functions?

634


Is primary key clustered or nonclustered?

641


Is it possible to pass parameters to triggers?

664


what is user defined functions? : Sql dba

641


What is a constraint?

654


Can you load data into multiple tables at once? : aql loader

700


What is a join?

723