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 <elkinsl_at_flash.net> 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
> 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).
>
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: wisernet100_at_yahoo.com
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 - 05:53:39 CST
