471,090 Members | 1,403 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,090 software developers and data experts.

update table a from table b

in Ingres I can do this

update table1 from table2
set table1.field = table2.field
where table1.id = table2.id

is there an equivalent in Oracle ?

Regards
Michael Newport
Jul 19 '05 #1
4 27892
Hello, michael,

About 02:20 01-Jul from mi************@yahoo.com accepted:
in Ingres I can do this

update table1 from table2
set table1.field = table2.field
where table1.id = table2.id

is there an equivalent in Oracle ?


update table1
set field = (
select field
from table2
where table2.id = table1.id
);

--
wbr,
Wit.
Jul 19 '05 #2
Hi Wit,

did I say thankyou ?

Thankyou.

been rather busy with work !

regards
Mike

a simple report is now an overnight pl/sql batch th
Jul 19 '05 #3
Hi Wit,

did I say thankyou ?

Thankyou.

been rather busy with work !

regards
Mike

a simple report is now an overnight pl/sql batch th
Jul 19 '05 #4
Hi Wit,

did I say thankyou ?

Thankyou.

been rather busy with work !

regards
Mike

a simple report is now an overnight pl/sql batch th
Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Lumpierbritches | last post: by
reply views Thread by gi75research | last post: by
5 posts views Thread by PAUL | last post: by
2 posts views Thread by madeleine.macphail | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.