Re: view in oracle designer 2000

Hi!
I can't remember the exact way to do that particular thing, but a very usefull and general hint for quickly
discovering how to do it is simply to execute your statement directly from SQL*plus and then retrofit
that particular object. You will find it much faster also. Brdgs.

-- 
Oliver Felix Fox
NCR SE-Copenhagen, Denmark
E-mail: Oliver.Fox_at_Copenhagen.ncr.com

Tommy Cami <Tommy.Cami_at_ufsia.ac.be> wrote in article
<32DCCEAE.1B4A_at_ufsia.ac.be>...


> 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

>