Update statement Oracle 1

[Zargo]

Hi all,

I want to update two columns, it doesnt work what do i wrong?

update supplier_data set a.supplier_num = b.supplier_num_new, a.comp_no = b.comp_no_new from supplier_conversion b, supplier_data a where a.supplier_num = b.SUPPLIER_NUM_OLD and a.comp_no = b.comp_no_old


TIA,

Zargo

 

[feherke]

Hi

Are you coming from PostgreSQL ? Because Oracle has no [tt]from[/tt] clause for the [tt]update[/tt] command. You have to use one or more sub-[tt]select[/tt]s.

Feherke.

http://rootshell.be/~feherke/

 

[Zargo]

Hi,

This is a standard Oracle9i query what i want to execute. Do you know how i must write the query?

Thanx a lot

 

[Dagon]

update supplier_data a
set (supplier_num, comp_no) = (select b.supplier_num_new, b.comp_no_new 
from supplier_conversion b
where a.supplier_num = b.SUPPLIER_NUM_OLD and 
a.comp_no = b.comp_no_old)
where exists
(select 1
from supplier_conversion b
where a.supplier_num = b.SUPPLIER_NUM_OLD and 
a.comp_no = b.comp_no_old)