Merge records in a table

CREATE TABLE FEE_COLL_DETAILS(  RECPT_NO                VARCHAR2(15 BYTE),  FEE_TYPE_ID             VARCHAR2(15 BYTE),  MONTH_YEAR              VARCHAR2(6 BYTE),  AMOUNT                  NUMBER(9,3),  FEE_CONCESSION_PERCENT  NUMBER(3),  STATUS                  VARCHAR2(1 BYTE),  CATEGORY                VARCHAR2(1 BYTE),  TERM                    VARCHAR2(1 BYTE),  REGNO                   VARCHAR2(15 BYTE),  OTHER_FEE_REMARK        VARCHAR2(25 BYTE),  TERMINATE_TRAN_ID       VARCHAR2(10 BYTE),  OTHER_FEE_ID            VARCHAR2(15 BYTE),  CANCELLED_AMT           NUMBER(9,3))/Insert into FEE_COLL_DETAILS   (RECPT_NO, FEE_TYPE_ID, MONTH_YEAR, AMOUNT, FEE_CONCESSION_PERCENT,    STATUS, CATEGORY, TERM, REGNO, OTHER_FEE_REMARK,    TERMINATE_TRAN_ID, OTHER_FEE_ID, CANCELLED_AMT)Values   ('0000089510', '001', '201701', 90, 0,    NULL, 'N', '2', NULL, NULL,    NULL, NULL, NULL);Insert into FEE_COLL_DETAILS   (RECPT_NO, FEE_TYPE_ID, MONTH_YEAR, AMOUNT, FEE_CONCESSION_PERCENT,    STATUS, CATEGORY, TERM, REGNO, OTHER_FEE_REMARK,    TERMINATE_TRAN_ID, OTHER_FEE_ID, CANCELLED_AMT)Values   ('0000089510', '001', '201609', 180, 0,    NULL, 'N', '1', NULL, NULL,    NULL, NULL, NULL);Insert into FEE_COLL_DETAILS   (RECPT_NO, FEE_TYPE_ID, MONTH_YEAR,