can a view be created from a union in Designer/2000
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