not a single-group group function ?

when i do this in the oracle, it says :-

select to_char(renewal_date),count(*)
 from foreign_worker_master";

question 1 : what's wrong ?

executeQuery() Failed:

        Message: ORA-00937: not a single-group group function

        Vendor: 937

question 2 : how do i group all the dates that begin with

28-NOV-99
30_NOV-99 to be 1 group ?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 26 1999 - 22:59:01 CDT