Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Single view on multiple tables?

Re: Single view on multiple tables?

From: Ken Rachynski <krachyn_at_cadvision.com>
Date: Fri, 19 Feb 1999 08:00:44 -0700
Message-ID: <36CD7C9C.38735101@cadvision.com>


James,

Thanks! I don't care whether it is updateable because I'm trying to design it for a lookup anyway.

James Petts wrote:

> CREATE VIEW yourview (key, other_field_alias) AS
> SELECT key, other_field FROM parts_order_table
> UNION
> SELECT key, other_field FROM work_orders_table;
>
> Note that because this view contains a set operator (UNION) it is not
> updateable.
>
> James
>

--
Ken Rachynski
Database Analyst
krachyn_at_cadvision.com
<http://www.cadvision.com/krachyn>
ICQ: 3113514 Received on Fri Feb 19 1999 - 09:00:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US