tháng 2 28, 2024
SELECT DISTINCT CIF_NO, sum (COL15) as "SODU_TGTT_BINHQUAN" from ITSHBHO.TH053_DTLS WHERE TRUNC(EOD_DATE) BETWEEN ('31 mar 2022') AND ('31 Dec 2022') group by cif_no
Hoặc
DECLARE
-- Declarations
l_P_TO_DATE VARCHAR2 (32767);
l_P_CUSTOMER_TYPE VARCHAR2 (32767);
l_P_CIF VARCHAR2 (32767);
l_P_TYPE VARCHAR2 (32767);
l_POS_FLG VARCHAR2 (32767);
l_P_POS_CD VARCHAR2 (32767);
l_AOUTCURSORDATA SYS_REFCURSOR;
BEGIN
-- TH053(P_TO_DATE=31/12/2022;P_CUSTOMER_TYPE=R;P_CIF=;P_TYPE=;pos_flg: G p_pos_cd: ______)
l_P_TO_DATE := '31/01/2022';
l_P_CUSTOMER_TYPE := 'I';
l_P_CIF := NULL;
l_P_TYPE := NULL;
l_POS_FLG := NULL;
l_P_POS_CD := NULL;
-- Call
ITSHBHO.TH053 (P_TO_DATE => l_P_TO_DATE,
P_CUSTOMER_TYPE => l_P_CUSTOMER_TYPE,
P_CIF => l_P_CIF,
P_TYPE => l_P_TYPE,
POS_FLG => l_POS_FLG,
P_POS_CD => l_P_POS_CD,
AOUTCURSORDATA => l_AOUTCURSORDATA);
-- Transaction Control
COMMIT;
-- Output values, do not modify
:7 := l_AOUTCURSORDATA;
END;
