Code:
INSERT INTO ABCD
(A,B,C,D,E,F,G)
(SELECT
LINE_ARR.A,
LINE_ARR.B,
REGEXP_SUBSTR( LINE_ARR.LINE_REC,'[^,]+',1,2),
XYZ.D ,
XYZ.E ,
REGEXP_SUBSTR( LINE_ARR.LINE_REC,'[^,]+',1,3),
SUM(TO_NUMBER(REGEXP_SUBSTR( LINE_ARR.LINE_REC,'[^,]+',1,4)))
FROM
(SELECT ? A, ? B, ? LINE_REC FROM DUAL) LINE_ARR,
XYZ
WHERE XYZ.X = REGEXP_SUBSTR( LINE_ARR.LINE_REC,'[^,]+',1,1)
GROUP BY
LINE_ARR.A,
LINE_ARR.B,
REGEXP_SUBSTR( LINE_ARR.LINE_REC,'[^,]+',1,2),
XYZ.D ,
XYZ.E ,
REGEXP_SUBSTR( LINE_ARR.LINE_REC,'[^,]+',1,3))