Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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).Received on Sat Dec 28 2002 - 01:23:46 CST
![]() |
![]() |