Function Function, in computer programming language context, a set of instructions which takes some input and performs certain tasks. In SQL, a function returns a value. Procedure Procedure, as well, is a set of instructions which takes input and performs certain task. In SQL, procedure does not return a value. In java, procedure and functions are same and also called sub-routines.