Re: Creating Views

From: Karen Abgarian <>
Date: Fri, 20 Aug 1999 17:22:06 -0400
Message-ID: <>

Hi Kenny,

The syntax for creating such a view is:

create view xxx as select a.cust_id, a.first_name, a.last_name, b.loves_children
from customer a, preferences b where <here goes join condition>;

If columns names coincide, use qualifiers, like newname. When you create
such a view, you may not be able to do all the operations against it, because there
is a number of restrictions. And I doubt it that Oracle will ever update two underlying
tables. See the manual and make sure you understand all the implications of modifying thru a view. And, it's really more easy to modify the base tables directly.

Karen Abgarian.

Kenny wrote:

> Hey all,
> Two part question:
> First, I am trying to create a view that joins two tables, both tables
> having the same primary key. After creating the view, if I then insert,
> update, or delete a record from that view, will it affect both tables?
> Second, Can someone tell me the syntax of joining two tables in the
> create view statement.
> I know its something like:
> create view combo as select cust_id, first_name, last_name from customer
> ( here is the part where I want to also select cust_id, first_name,
> last_name from another table called preferences)
> Any info would be great..
> Regards
> -Kenny
> p.s. please respond to my email
Received on Fri Aug 20 1999 - 23:22:06 CEST

Original text of this message