Re: update several rows from a select???

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 7 May 2007 17:56:30 +0200
Message-ID: <463f4c2c$0$446$426a74cc@news.free.fr>

"valigula" <valigula_at_gmail.com> a écrit dans le message de news: 1178553186.644822.101800_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 Received on Mon May 07 2007 - 10:56:30 CDT