Re: view in oracle designer 2000

[Quoted] On Wed, 15 Jan 1997 13:33:50 +0100, Tommy Cami <Tommy.Cami_at_ufsia.ac.be> wrote:

>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

There is a button labeled "Text" in the "Edit View:" dialog box of Data Diagrammer. Select Text Type "Where/Validation Condition" and enter desired where, group, etc. clause.

jacek Received on Thu Jan 16 1997 - 00:00:00 CET