Re: update several rows from a select???

From: valigula <valigula_at_gmail.com>
Date: 7 May 2007 10:56:56 -0700
Message-ID: <1178560616.477084.298790@e51g2000hsg.googlegroups.com>

On 7 mayo, 17:56, "Michel Cadot" <micadot{at}altern{dot}org> wrote:

> "valigula" <valig..._at_gmail.com> a écrit dans le message de news: 1178553186.644822.101..._at_y5g2000hsa.googlegroups.com...

> | update tbl r set
> | (c1, c2, c3,c4,
> | c5, c6, c7)=
> | ( SELECT distinct c1, c2, c3,c4,
> | c5, c6, c7
> | from tbl i
> | where i.c8= r.c8
> | and i.c7> r.c7
> | )
> |
> |
> | i am trying to update several rows from a select this rows can be up
> | to 500k.
> | this is a huge time consuming for this.
> |
> | Is it a better way of doing it???
> |
> | Thanks in advance
> |
> | A
> |

>
> As we answer one hour ago in c.d.o.m: use MERGE command.
>
> And don't multipost but you can reply in the original if our
> answer doesn't fit your requirement. Just tell why.
>
> And POST YOUR ORACLE VERSION as Daniel already
> asked you.
>
> Regards
> Michel Cadot

oopps ... sorry for posting twice i just check the answer and that siuts perfect what i need ....

ty Received on Mon May 07 2007 - 12:56:56 CDT