What is difference between a PROCEDURE & FUNCTION ?

Answer Posted / naresh bs

The main difference is that, a procedure may return and
value but a function has to return a value.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are sql*plus environment variables?

559


What is the difference between a subquery and a join?

530


Is a table valued function object?

583


Is sql a dbms?

536


What is data type in database?

549






How to add, remove, modify users using sql?

561


what is a trigger in mysql? : Sql dba

605


Why do we use joins?

568


How is data stored on a disk?

544


what is not null constraint? : Sql dba

552


How many joins in sql?

559


Explain what is a view?

600


explain the options of myisamchk to improve the performance of a table. : Sql dba

549


differentiate between float and double. : Sql dba

563


what are the non-standard sql commands supported by 'mysql'? : Sql dba

573