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

Brian Gastineau wrote:
>
> 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

I've been having the same problem. The only way to get around it is to specify the 'second' part of your union as a part of the where clause (in plain text). Of course this is not disireable because of the lack of table usage references and not using the features of the Data Diagrammer tool.

However, by setting 'Free format declaration' to FALSE you might be able to specify all your referenced tables and still generate the entire view using the above method.

PS: If you got the expected dates from someone, I would be interested too! Thanks Received on Fri Oct 11 1996 - 00:00:00 CEST