Row_number and sum are part of ANSI SQL!
You could use common table expressions/recursive subquery factoring:
with rws (r) as (
select 1 r from dual
union all
select r+1 r from rws
where r < 10
)
select * from rws;
R
1
2
3
4
5
6
7
8
9
10
Or other ways shown at:
https://blogs.oracle.com/sql/entry/fizzbuzz