update a table from another table using oracle db

Question

I have to update one table from another one: I can do the update with the MySQL sgbd:

update product pr ,  provider p 
set pr.provider_name = p.name 
where p.provider_id = pr.provider_id ;

but when I try to do it with oracle : I tried this query for oracle

UPDATE pr 
SET pr.provider_name = p.name 
FROM product pr 
INNER JOIN provider p ON p.provider_id = pr.provider_id  ;

I get this error:

Error Code: 933, SQL State: 42000]  ORA-00933: SQL command not properly ended

What's wrong with my query?

Ionic · Accepted Answer · 2015-06-23 14:21:44Z

2

Try this instead:

UPDATE product
SET provider_name = (
    SELECT p.name 
    FROM provider p 
    WHERE p.provider_id = product.provider_id
);

answered Jun 23, 2015 at 14:21

Ionic

3,9451 gold badge14 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user4900638 · Accepted Answer · 2015-06-23 14:23:40Z

2

UPDATE product prod SET prod.provider_name = (SELECT prov.name
                                                FROM provider prov 
                                               WHERE prod.provider_id = prov.provider_id)

answered Jun 23, 2015 at 14:23

user4900638

Collectives™ on Stack Overflow

update a table from another table using oracle db

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related