Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: update several rows from a select???

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US