아래쿼리문에서 BETWEEN 값이 00건씩 증가 될수 있는 프로시져 생성문을 어떻게 많드는지 문의 드립니다.
MERGE /*+LEADING(A) USE_NL(A) */
INTO NSCREEN.N_USER_INFO NU USING (
SELECT /*+ LEADING(B) USE_NL(A) */B.NU_USER_ID,
SUM(FI_SIZE) SUM_FI_SIZE,
COUNT(*)
FROM N_FILE_TB A,
N_USER_INFO B
WHERE B.NU_USER_ID = A.FI_U_ID
AND B.NU_ID BETWEEN 401 AND 500
AND A.FI_STATUS IN (1, 2)
GROUP BY B.NU_USER_ID) A ON (A.NU_USER_ID = NU.NU_USER_ID
)
WHEN MATCHED THEN
UPDATE
SET NU.NU_REMAINSIZE = A.SUM_FI_SIZE
|