Re: Last Row Inserted

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 06 Sep 2005 12:58:25 -0700
Message-ID: <1126036673.868726@yasure>

at"@ wrote:
> DA Morgan wrote:
>

>>Nothing prevents you from loading Table2 with the query of your choice.
>>Nothing prevents you from doing an insert into Table2.
>>
>>What do you see as being the issue(s)?

>
>
> If I create an writeable materialized view and insert into it, won't the
> data that I insert be copied over to the master table?

How could it be?

You need to learn the basic concepts underlying materialized views as opposed to regular views. I'd suggest starting with the Concepts books at tahiti.oracle.com.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Tue Sep 06 2005 - 14:58:25 CDT