Answer Detail: RE: What is difference between Procedures and Functions ?

GeekInterview.com > Interview Questions > Oracle > Programmatic Constructs

Print |

Question:

What is difference between Procedures and Functions ?

Answer:

A Function returns a value to the caller where as a Procedure does not.

August 08, 2008 01:06:42	#3
chloroone	Member Since: August 2008 Total Comments: 1
RE: What is difference between Procedures and Functions ?
Function always returns a value. Procedure may or may not return a value. Functions can be called in SQL statements. Procedure can not be called in an SQL statement.