it's pretty cool no matter who posts it! :) I ended up writing a quick and dirty pl/sql procedure one night at 3AM when we were in crisis mode and I couldn't remember how to write the darn thing!
so this is going on ALL my computers --- Larry Elkins <[EMAIL PROTECTED]> wrote: > 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 > [EMAIL PROTECTED] > 214.954.1781 > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
