What is difference between a PROCEDURE & FUNCTION ?

Answer Posted / anil kumar jampana

sorry, we can use in,inout,out parameters in functions also.
one more diff. we can use functions in normal sql queries
but we cann't use procedures in sql queries....

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are sql triggers used for?

515


How many triggers can be applied to a table?

600


what are the drivers in mysql? : Sql dba

554


What is a primary key sql?

565


What are string functions in sql?

678






What is bulk collect in pl sql?

535


Enlist the advantages of sql.

573


What is the use of index in hive?

548


define sql delete statement ? : Sql dba

560


What is program debugging?

566


What are different types of tables in sql?

531


What is procedure and function in sql?

534


What are the built in functions of sql?

567


what is union? : Sql dba

586


What are different types of keys?

524