view in oracle designer 2000

[Quoted] [Quoted] I want to create a view in Oracle with the designer 1.2a something like the following :

create view
...
select StudentID, Sum(Credit)
from table
group by StudentID;

Most of the DDL is generated until the group part. Where can i define the group without changing the sql statement directly.

thanks beforehand

Tommy cami
Tommy.Cami_at_ufsia.ac.be
University of antwerp Received on Wed Jan 15 1997 - 00:00:00 CET