Update statement
From: twoboats <member_at_dbforums.com>
Date: Fri, 22 Nov 2002 15:35:21 +0000
Message-ID: <2077078.1037979321_at_dbforums.com>
Date: Fri, 22 Nov 2002 15:35:21 +0000
Message-ID: <2077078.1037979321_at_dbforums.com>
I've come from MSSQL to Oracle. Can any Oracle guru tell me if there's a
mechanism in PLSQL that equates to the transact sql version of update
that allows the update statement to use more than one table i.e. in TSQL
you can do
update b
set b.field1 = t.field1
from sqlloadtable t, basetable b
where b.key = t.key
--
Posted via http://dbforums.com
Received on Fri Nov 22 2002 - 16:35:21 CET