Update templ.sat_subject_attrs sat_subj
set time_to=
(
select max(time_to_new) from 
 (
  select 
  ssa.subj_id, ssa.time_from,
   coalesce(lead (ssa.time_from, 1) over(
      partition by ssa.subj_id order by ssa.time_from asc), 
      to_Date('9999-12-31 00:00:00', 'YYYY-MM_DD HH24:MI:SS'))
      as time_to_new
  from templ.sat_subject_attrs ssa
  where ssa.subj_id=429230
 )sat_subj_new
    where sat_subj_new.subj_id=sat_subj.subj_id and
      sat_subj_new.time_from=sat_subj.time_from 
 )
 where sat_subj.subj_id=429230

При таком update, будет получен результат 
subj_id              time_from                   time_to
429230		1999-09-24 00:00:00	  2000-01-14 00:00:00
429230		1999-09-24 00:00:00	  2000-01-14 00:00:00
429230		2000-01-14 00:00:00	  2004-12-14 00:00:00
429230		2000-01-14 00:00:00	  2004-12-14 00:00:00
429230		2004-12-14 00:00:00	  2007-04-10 00:00:00
429230		2007-04-10 00:00:00	  2014-10-29 14:32:28
429230		2014-10-29 14:32:28  9999-12-31 00:00:00

Как переписать, чтобы получить следующий результат

subj_id                time_from                     time_to
429230		1999-09-24 00:00:00	  1999-09-24 00:00:00
429230		1999-09-24 00:00:00	  2000-01-14 00:00:00
429230		2000-01-14 00:00:00	  2000-01-14 00:00:00
429230		2000-01-14 00:00:00	  2004-12-14 00:00:00
429230		2004-12-14 00:00:00	  2007-04-10 00:00:00
429230		2007-04-10 00:00:00	  2014-10-29 14:32:28
429230		2014-10-29 14:32:28  9999-12-31 00:00:00