can a view be created from a union in Designer/2000

From: Brian Gastineau <gastineau_at_ghgcorp.com>
Date: 1996/10/23
Message-ID: <01bbc116$0c2652a0$061fcd8d_at_LO4153.dns.lmco.com>#1/1


Is it possible to represent a view whose select statement is a union in Designer/2000 (specifically the Data Diagrammer)? The DDL I am trying to capture is something to the effect of

CREATE OR REPLACE VIEW person_view
( person_number ,name )
AS

    SELECT       customer_number    ,name
    FROM          customer_table
UNION
    SELECT       employee_number   ,name
    FROM          employee_table

;

I have been able to get a view from Designer/2000 for a single select statement, but the "Base Relations" and "Base Cols" doesn't seem to support the more complicated union.

ANOTHER QUESTION: Does anyone have inside information on the expected date of release for the "Introduction to Designer/2000" by Anderson and Wendelken or the "Oracle Designer/2000 Handbook" by Dorsey?

Thanks,
Brian Gastineau
gastineau_at_ghgcorp.com
Engineering Systems Analyst
Lockheed-Martin Space Information Systems Received on Wed Oct 23 1996 - 00:00:00 CEST

Original text of this message