[QUOTE][i]Originally posted by trev [/i]
[B]Im getting this error message



1 select a.color, trunc( ratio_to_report(count(a.color)) over() * 100, 2) as percentage
2 from test
3* group by a.color
4 /
select a.color, trunc( ratio_to_report(count(a.color)) over() * 100, 2) as percentage
*
ERROR at line 1:
ORA-00907: missing right parenthesis

[/B][/QUOTE]

Answer:

line2 should be "test a", mine just works.
Make sure it is the right version of database;

Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production