SQL & PL/SQL

SQL> select version from v$instance;

VERSION
-----------------
10.2.0.1.0

SQL> select Val,
  2  First_Value(case when mod(Val,10) = 0 then Val end ignore nulls)
  3  over(order by Val Range Between Current row and Unbounded Following)
  4  as "aaa"
  5  from (select 10 as Val from dual
  6  union select 15 from dual
  7  union select 20 from dual
  8  union select 25 from dual
  9  union select 30 from dual
 10  union select 32 from dual
 11  union select 34 from dual
 12  union select 40 from dual);

VAL  aaa
---  ---
 10   10
 15   20
 20   20
 25   30
 30   30
 32   40
 34   40
 40   40

SQL> select Val,
  2  First_Value(case when mod(Val,10) = 0 then Val end ignore nulls)
  3  over(order by Val Range Unbounded Following)
  4  as "aaa"
  5  from (select 10 as Val from dual
  6  union select 15 from dual
  7  union select 20 from dual
  8  union select 25 from dual
  9  union select 30 from dual
 10  union select 32 from dual
 11  union select 34 from dual
 12  union select 40 from dual);
over(order by Val Range Unbounded Following)
                                  *
ORA-00905: missing keyword.