Re: Update statement
Date: Fri, 22 Nov 2002 17:53:26 GMT
Message-ID: <qauD9.4313$wc2.267860_at_news2.east.cox.net>
Two options that I know of:
update basetable b
set b.field1 =
(select t.field1 from sqlloadtable t where b.key = t.key);
or
update basetable b
set b.field1 =
(select t.field1 from sqlloadtable t where b.key = t.key)
where exists
(select * from sqlloadtable t where b.key = t.key);
2) Update a derived table that is the result of a join of sqlloadtable and basetable.
update
(select b.key, b.field1 b_field, t.field1 t_field
from sqlloadtable t, basetable b
where b.key = t.key)
set b_field = t_field;
"twoboats" <member_at_dbforums.com> wrote in message
news: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
>
> Basically, I have a table that I'm updating from data sent in a file
> that's loaded into a worktable using sqlload.
>
> Thanks in advance.
>
> Would appreciate email copies of replies to
> wayne.smith_at_rbs.co.uk
>
> --
> Posted via http://dbforums.com
Received on Fri Nov 22 2002 - 18:53:26 CET