What is Difference between StoredProcedure and function?

Answer Posted / shankar

FUNCTION always return a value where as PROCEDURE may or
may not return value.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is aggregate function in sql?

529


what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

541


What is a sql select statement?

562


Write a sql query to find the names of employees that begin with ‘a’?

574


How do you explain an index?

784






How does postgresql compare to mysql?

573


What are the parameter modes supported by pl/sql?

528


What is the life of an sql statement?

519


Is sqlite free?

529


how to use in conditions? : Sql dba

508


What is sql procedures and functions?

526


What is a loop in sql?

562


What plvcmt and plvrb does in pl/sql?

872


What is benefit of creating memory optimized table?

535


What is mutating sql table?

602