存储过程、函数在实际应用中有什么区别

 

请问存储过程、函数在实际应用中有什么区别？

A stored procedure does something without returning a value while a function does something with a return value. There's no magic here. Any programming language is like this except some languages use different names from procedure / function.

In sqlplus,
To call a procedure
exec myproc(1,2,3)
To call a function
var a number
exec :a := myfunc(1,2,3)
assuming it returns a number, and both myproc and myfunc accept 3 arguments of type number