01.
DROP
FUNCTION
IF EXISTS getDiffAmount;
02.
03.
DELIMITER //
04.
CREATE
FUNCTION
getDiffAmount(pAmt1
DECIMAL
(18,2),pAmt2
DECIMAL
(18,2))
05.
RETURNS
DECIMAL
(18,2)
06.
BEGIN
07.
DECLARE
diffAmt
DECIMAL
(18,2);
08.
09.
SET
diffAmt = pAmt1 - pAmt2;
10.
11.
RETURN
diffAmt;
12.
END
//
13.
DELIMITER ;