Procedure Versus Function (www.oraclepass port.com)

Procedure Versus Function

a. Only function can Return a value (to be precise using the Return keyword)

b.Procedures can use ‘Return’ keyword but without any value being passed

c.Functions could be used in select statements, provided they doesn’t do any data manipulation inside and also should not have any OUT, IN OUT parameters....