oracle start with

select * from t where 1=1 
START WITH key_id=600 CONNECT BY PRIOR key_id = pid
order by key_id desc