SQL>  select HIREYEAR,count
  2   from
  3   (
  4   select to_char(HIREDATE,'yyyy ') HIREYEAR,count(0) count
  5   from scott.emp
  6   where to_char(HIREDATE,'yyyy ') in (1981,1982,1987)
  7   group by to_char(HIREDATE,'yyyy ')
  8  )
  9   MODEL   
 10   DIMENSION BY (HIREYEAR)
 11   MEASURES (count)
 12    RULES (
 13    count['total'] = sum(count)[HIREYEAR IN (1981,1982,1987)] )
 14  /

HIREY      COUNT
----- ----------
1982           1
1981          10
1987           2
total         13

SQL> select extract(year from sysdate) from dual;
EXTRACT(YEARFROMSYSDATE)
------------------------
                    2009

1 row selected.

SQL> SELECT   DECODE (GROUPING (EXTRACT (YEAR FROM hiredate)),
  2                   1, 'TOTAL',
  3                   EXTRACT (YEAR FROM hiredate)
  4                  ) hireyear,
  5           COUNT (0) cou
  6      FROM scott.emp
  7     WHERE TO_CHAR (hiredate, 'yyyy') IN (1981, 1982, 1987)
  8  GROUP BY ROLLUP (EXTRACT (YEAR FROM hiredate))
  9  /

HIREYEAR                                        COU
---------------------------------------- ----------
1981                                             10
1982                                              1
1987                                              2
TOTAL                                            13

create or replace type ty_timing_table as table of number;
/

declare
  
  t_timing    ty_timing_table := ty_timing_table();
  
  v_iter      pls_integer := 10000;
  v_max       pls_integer := 100;
  v_time      pls_integer;
  v_avg       number;
  v_total     pls_integer;
  v_stddev    number;
  v_num       number;
  
begin
  t_timing.delete;
  t_timing.extend(v_iter);

  for i in 1..v_iter loop
    v_time := dbms_utility.get_time;
    
    for i in 1..v_max loop
      v_num := extract(year from sysdate-v_max*5);
    end loop;
    
    t_timing(i) := dbms_utility.get_time - v_time;
  end loop;
  
  select avg(column_value)
        ,stddev(column_value)
        ,sum(column_value)
  into   v_avg,v_stddev,v_total
  from   table(t_timing);
  
  dbms_output.put_line('Test 1: Total: '||v_total||' Avg: '||round(v_avg,3-trunc(log(10,v_avg)))||' stddev: '||round(v_stddev,3));
  
  t_timing.delete;
  t_timing.extend(v_iter);

  for i in 1..v_iter loop
    v_time := dbms_utility.get_time;
    
    for i in 1..v_max loop
      v_num := to_char(sysdate-v_max*5,'yyyy');
    end loop;

    
    t_timing(i) := dbms_utility.get_time - v_time;
  end loop;
  
  select avg(column_value)
        ,stddev(column_value)
        ,sum(column_value)
  into   v_avg,v_stddev,v_total
  from   table(t_timing);
  
  dbms_output.put_line('Test 1: Total: '||v_total||' Avg: '||round(v_avg,3-trunc(log(10,v_avg)))||' stddev: '||round(v_stddev,3));  
  
end;

Test 1: Total: 139 Avg: .0139 stddev: .16
Test 1: Total: 163 Avg: .0163 stddev: .166