How to Fix ORA-00933 Error in Oracle UPDATE Query Using a JOIN?-Mysql Tutorial-php.cn

How to Fix ORA-00933 Error in Oracle UPDATE Query Using a JOIN?

Susan Sarandon

Release： 2024-12-28 05:07:13

Original

902 people have browsed it

How to Fix ORA-00933 Error in Oracle UPDATE Query Using a JOIN?

Resolving ORA-00933 Error in Oracle Update Query using Join

In an attempt to update the amount column using a join query, an exception has been encountered: ORA-00933, indicating an improperly ended SQL command.

The initial query was:

UPDATE tab1
SET tab1.total_adjusted_cost = tab1.total_adjusted_cost + t1.total
FROM table1 tab1, 
(SELECT tab3.name, tab3.add, SUM(tab2.amount) AS total
FROM table2 tab2,
table3 tab3,
table4 tab4
WHERE tab2.id = tab3.id
AND tab3.id = tab4.id
AND tab4.indicator = 'Y'
GROUP BY tab3.name, tab3.add ) t1
WHERE tab1.id = t1.id;

Copy after login

To rectify this error and successfully execute your update, it is recommended to employ a merge statement instead of a join query. The following merge statement can be used:

merge into table1 tab1 
using
(
SELECT tab3.name, tab3."add", SUM(tab2.amount) AS total
FROM table2 tab2,
table3 tab3 ,
table4 tab4
WHERE tab2.id        = tab3.id
AND tab3.id            = tab4.id
AND tab4.indicator             ='Y'
GROUP BY tab3.name,
tab3."add"
)t1
on(tab1.id      = t1.id)
when matched then 
update set tab1.total_adjusted_cost = tab1.total_adjusted_cost + t1.total

Copy after login

The above is the detailed content of How to Fix ORA-00933 Error in Oracle UPDATE Query Using a JOIN?. For more information, please follow other related articles on the PHP Chinese website!