create table test (
    test_id number( 9 )
  , value number( 9 )
)
/
insert into test (test_id, value)
  select rownum, rownum from all_objects where rownum <  100 
/
commit;

select *
from (select test_id
           , value
           , sum(value) over (order by test_id range unbounded preceding) sum_value
      from test
   )
where sum_value <=  10 
/

select *
from (select test_id
           , value
           , sum(value)
               over (
                 order by test_id
                 rows between unbounded preceding and current row
               ) sum_value
      from test
   )
where sum_value <=  10