create CURSOR sequence (nval n(3,0)) >>INSERT INTO sequence VALUES (1) >>INSERT INTO sequence VALUES (2) >>INSERT INTO sequence VALUES (4) >>INSERT INTO sequence VALUES (5) >>INSERT INTO sequence VALUES (6) >>INSERT INTO sequence VALUES (9) >>INSERT INTO sequence VALUES (11) >>INSERT INTO sequence VALUES (12) >>INSERT INTO sequence VALUES (15) >> >>SELECT x.nval+1 gapstart, MIN(y.nval)-1 AS gapend ; >> FROM sequence x, sequence y ; >> WHERE x.nval < y.nval ; >> GROUP BY x.nval ; >> HAVING gapend - x.nval >= 1 >> >>>>