We're moving a SQL Server database to Oracle. I have difficulty in
converting this update query to PL/SQL. The query involves three tables, and
ran fine in SQL Server. But I just can't figure out how to rewrite it as I'm
totally new to PL/SQL.

UPDATE AAA
SET AAA.mm = BBBB.nn, AAAA.xx = BBB.yy
from (BBB INNER JOIN CCC ON (BBB.ee = CCC.ff))
INNER JOIN AAA ON (CCC.pp = AAA.qq) AND (BBB.ss = AAA.tt)

As there are millions of records in those tables, each run on SQL server
takes about 1 hour or so. Hopefully it wouldn't take too long on Oracle.

Thanks.

John61 wrote:
www.psoug.org
click on Morgan's Library
click on Update

also check out:
http://tahiti.oracle.com
http://asktom.oracle.com

And you might want to consider not using the ANSI syntax. It is
verbosity without purpose. But don't expect Oracle to be faster
than SQL Server if you haven't read up on Oracle and learned how
to leverage its better technology.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)