12-02-17, 07:12 PM
وعليكم السلام
هذه هي StoredProcedure
هذه هي StoredProcedure
PROCEDURE GETBLANCE
)
COUNTRY OUT VARCHAR2,
DONATION OUT VARCHAR2,
CR OUT FLOAT,
DB OUT FLOAT,
D1 IN Date,
D2 IN Date,
TRANS IN INTEGER,
DONT IN INTEGER
(
AS
BEGIN
select COUNTRY,DONATION,SUM(NVL(NET_LAMT_DB,0)) DB,SUM(NVL(NET_LAMT_CR,0)) CR INTO COUNTRY,DONATION,DB,CR
From TEST
WHERE TRANS_DATE BETWEEN D1 and D2
AND TRNS_UNT=TRANS
AND DON_TP_NO=DONT
;GROUP BY COUNTRY,DONATION
END