MS SQL Server syntax to Oracle

From: fgsdfgsdf <sdfgdfg_at_nospam.se>
Date: Tue, 17 Apr 2007 09:31:25 GMT
Message-ID: <Nt0Vh.56$Bz6.4@read3.inet.fi>

Hi all

I have this update statement written for MS SQL Server and need the same statement for Oracle (version 9).
I can not find a way to do joins in an update statement in Oracle - is it possible?

update Ver

set      Ver.ObjectCreatedBy = c.CreatedBy,
          Ver.ObjectCreated = c.Created
from   Ver
          join (
            select Object, CreatedBy, Created
            from  Ver
                   join (
                        select Object Obj, min(created) Cre
                        from   Ver
                        group by Object
                        ) b on Ver.Object = b.Obj and Ver.Created = b.Cre
            ) c on Ver.Object = c.Object

Thanks for your help
Stefan Olofsson Received on Tue Apr 17 2007 - 04:31:25 CDT