RE: Row Migration

Actually, I first learned that trick from a Connor posting on this list (maybe around 2 or 3 years ago?) It has to conform to the same key preserved rules that updateable views do since that's what it is, just an in-line view as opposed to an actual physical view. So supposedly it's been available since 7.x when updateable views came along (and in-line views). There is an example in the Data Warehousing Guide (I think that's the one) in the 8i documentation, though the example is wrong (it omits the FROM clause). Anyway, I thought it was pretty cool the first time I saw Connor post it.

Regards,

Larry G. Elkins
elkinsl_at_flash.net
214.954.1781

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rachel
> Carmichael
> Sent: Friday, December 27, 2002 10:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Row Migration
>
>
> don't feel too sheepish, I didn't know it either. Larry is the SQL guru
> and I bow to his knowledge. and had already saved off this email as
> this sort of update is something we do often and I ALWAYS have problems
> figuring out the correct SQL :)
>
> rachel
> --- Jared Still <jkstill_at_cybcon.com> wrote:
> >
> > Geez, I didn't know you could do that.
> >
> > Sheepishly,
> >
> > Jared
> >
> > On Friday 27 December 2002 03:38, Larry Elkins wrote:
> > > Someone asked in a back channel email if parallelism is used. The
> > select
> > > portion of the update statement uses parallelism (though the
> > updates
> > > themselves get serialized) through the use of an in-line join
> > update (to
> > > avoid the second sub-query commonly used to constrain the rows
> > being
> > > updated):
> > >
> > > Update (Select /*+ parallel hints */ ....
> > > From a,b
> > > Where a.key = b.key)
> > > Set a.col1 = b.col1,
> > > a.col2 = b.col2
> > > .....

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Larry Elkins
  INET: elkinsl_at_flash.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).