Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 2nd table
mike7..._at_gmail.com wrote:
> What is the easiest way to update a 2nd table based on data in a
> materialized view of a 1st table? The 1st table and 2nd table should
> be identical following the update.
>
> Thanks.
Funny how you think the Oracle release has no bearing on the answer; it matters much. For any release older than 9.0.1 you're stuck using a PL/SQL block to provide insert/update capability. From 9.0.1 onwards (with 9.2.0 and later releases providing a more stable implementation) there is MERGE INTO. Not knowing WHICH release you're using prevents any further discussion on the matter.
Provide the full Oracle version you're using and more appropriate assistance can be given. Or, read the fantabulous manuals at http://tahiti.oracle.com. The time you took to post here and wait for a response would have been better used reading the documentation.
David Fitzjarrell Received on Wed Aug 09 2006 - 13:39:49 CDT