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 from a subquery

Re: Update from a subquery

From: Noel <tomekb_XXXX__at_softman.pl>
Date: Sat, 28 Aug 2004 14:45:20 +0200
Message-ID: <cgpuks$qs8$1@inews.gazeta.pl>


>> update X
>> set (A, B, C) = (
>> select D, min(E), min(F)
>> from Y
>> group by D
>> ) Y1
>> where X.A = Y1.D

> 
> 
> Did you try?

I think he did.
And got ORA-00933 error. (syntax error).

--
Noel
Received on Sat Aug 28 2004 - 07:45:20 CDT

Original text of this message

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