update table a from table b

#1

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

#2

Hello, michael,

About 02:20 01-Jul from michaelnewport (AT) yahoo (DOT) com accepted:

Quote:

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.

#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

#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

#5

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

update table a from table b

comp.databases.oracle comp.databases.oracle

update table a from table b - 07-01-2004 , 04:20 AM

Re: update table a from table b - 07-01-2004 , 04:32 AM

Re: update table a from table b - 07-12-2004 , 01:07 AM

Re: update table a from table b - 07-12-2004 , 01:07 AM

Re: update table a from table b - 07-12-2004 , 01:07 AM