SQL & PL/SQL

Hello All,

CREATE TABLE XX_LEAVE_RECORDS

(EMP_NUMBER VARCHAR2(20),

START_DATE DATE,

END_DATE DATE,

LEAVE_TYPE VARCHAR2(20),

NOTES1 VARCHAR2(200),

NOTES2 VARCHAR2(200),

NOTES3 VARCHAR2(200))

2 DAYS LEAVE consecutive

INSERT INTO XX_LEAVE_RECORDS

SELECT '9213', TO_DATE('01-01-2017', 'DD-MM-YYYY'), TO_DATE('02-01-2017','DD-MM-YYYY'),'SICK',NULL,NULL,NULL FROM DUAL

3 DAYS LEAVE consecutive

INSERT INTO XX_LEAVE_RECORDS

SELECT '9213', TO_DATE('03-01-2017', 'DD-MM-YYYY'), TO_DATE('05-01-2017','DD-MM-YYYY'),'SICK',NULL,NULL,NULL FROM DUAL

1 DAY LEAVE consecutive

INSERT INTO XX_LEAVE_RECORDS

SELECT '9213', TO_DATE('06-01-2017', 'DD-MM-YYYY'), TO_DATE('06-01-2017','DD-MM-YYYY'),'SICK',NULL,NULL,NULL FROM DUAL

COMMIT

Need Query  to identify total consecutive leave days taken.

Thanks in Advance.

Regards,

Afzal.