WITH t AS
(
SELECT 'a' id, '20130101020000' dt, 0 v FROM dual
UNION ALL SELECT 'a', '20130101040000', 1 FROM dual
UNION ALL SELECT 'a', '20130101060000', 0 FROM dual
UNION ALL SELECT 'a', '20130101140000', 1 FROM dual
UNION ALL SELECT 'a', '20130101160000', 0 FROM dual
UNION ALL SELECT 'a', '20130101170000', 0 FROM dual
UNION ALL SELECT 'a', '20130101200000', 1 FROM dual
UNION ALL SELECT 'a', '20130101240000', 0 FROM dual
)
SELECT id, dt, dt2
  FROM (SELECT id, dt, v
             , LEAD(dt) OVER(PARTITION BY id ORDER BY dt) dt2
             , LEAD(v ) OVER(PARTITION BY id ORDER BY dt) v2
          FROM t
        )
 WHERE v  = 1
   AND v2 = 0
;