What are Return Statement and OUT Parameter in PLSQL Function?

Database Steve

 Profile Answers by Database Steve Questions by Database Steve

• May 20th, 2009

Functions always return a value.Procedures do not.The use of IN, OUT, and IN_OUT parameters as scalar values or ref cursors is dependent on your need and overall performance not on a pseudo-standard as answered above.

KD09714

 Profile Answers by KD09714 Questions by KD09714

• Jun 28th, 2008

Function must have return statement by which it returns one value.Though we can use out parameter in function(function not getting called from select statement or DML), it is not good programming prac...

Answer Question  Select Best Answer