如何在Oracle上使用JOIN使用“FOR UPDATE”？(How can I use “FOR UPDATE” with a JOIN on Oracle?)

 另一个SO问题的答案是使用此SQL查询： 
 
SELECT o.Id, o.attrib1, o.attrib2 
  FROM table1 o
  JOIN (SELECT DISTINCT Id 
          FROM table1, table2, table3 
         WHERE ...) T1 ON o.id = T1.Id
 
 现在我想知道如何将此语句与关键字FOR UPDATE一起使用。 如果我只是将其附加到查询中，Oracle会告诉我： 
 
 
 
 ORA-02014：无法从视图中选择FOR UPDATE 
 
 
 我是否必须修改查询，或者是否有使用Oracle执行此操作的技巧？ 使用MySql，语句可以正常工作。 

The answer to another SO question was to use this SQL query:
 
SELECT o.Id, o.attrib1, o.attrib2 
  FROM table1 o
  JOIN (SELECT DISTINCT Id 
          FROM table1, table2, table3 
         WHERE ...) T1 ON o.id = T1.Id
 
Now I wonder how I can use this statement together with the keyword FOR UPDATE. If I simply append it to the query, Oracle will tell me:
 
 
 
ORA-02014: cannot select FOR UPDATE from view 
 
 
Do I have to modify the query or is there a trick to do this with Oracle? With MySql the statement works fine.

原文：https://stackoverflow.com/questions/2586014