Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need some query help
Hi,
Ok. The merge statement is 9i and up. Not available in 7. The statement won't work, because you can't update a query with a group by. Oracle needs to be able to decide a rowid to update, and group by prohibits this.
The only other alternative I can think of for the moment is to use a temporary table.
Regards,
Arian Received on Mon Feb 27 2006 - 12:27:14 CST