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: Need some query help

Re: Need some query help

From: Alien <stijf_at_stijf.com>
Date: 27 Feb 2006 10:27:14 -0800
Message-ID: <1141064834.193358.215090@i39g2000cwa.googlegroups.com>


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

Original text of this message

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