Hi,

PFB the sample data.

CREATE TABLE "MY_TABLE"
("NBR" VARCHAR2(20 BYTE),
"MO_YR" NUMBER,
"EFF_DT" DATE
) ;

INSERT INTO MY_TABLE (NBR, MO_YR, EFF_DT) VALUES('101',201310,Sysdate-20);
INSERT INTO MY_TABLE (NBR, MO_YR, EFF_DT) VALUES('102',201310,Sysdate-15);
INSERT INTO MY_TABLE (NBR, MO_YR, EFF_DT) VALUES('103',201310,Sysdate-10);
INSERT INTO MY_TABLE (NBR, MO_YR, EFF_DT) VALUES('104',201310,Sysdate-5);
INSERT INTO MY_TABLE (NBR, MO_YR, EFF_DT) VALUES('105',201310,Sysdate);
COMMIT;
SELECT * FROM MY_TABLE;

Here, i need to get a dataset like this.

Prev. | Old | Eff DT
105 104 Sysdate
104 103 Sysdate-5
103 102 Sysdate-10
102 101 Sysdate-15

As you can see, i need to merge the two consecutive records in the above fashion. Thanks in advance.