您可以同时使用连接和更新的组合。

例如

You can use a combination of join and update together.
For e.g

UPDATE
    tableA
SET
    A.columnA = B.ColumnA
FROM
    tableA A 
    JOIN
    tableB B ON A.columnB = B.columnB

您好，



查看这些....





我想更新n个行项目值。 [ ^ ]





如何在oracle中编写FOR UPDATE语句以将值设置为列 [ ^ ]





希望这些能帮到你。





干杯

Hi,

Check These....


I want to update n number of row item value.[^]


How to write FOR UPDATE statement in oracle for setting value to a column[^]


Hope these will help you.


Cheers