FUNCTION.md

FUNCTION

Similar to PROCEDURE except it returns a value.

-- Syntax
CREATE OR REPLACE FUNCTION FunctionName (Parameter IN VARCHAR)
RETURNS VARCHAR 
AS
BEGIN
-- Calculations part...
RETURN value;
END;