你即將離開本站

並前往https://stackoverflow.com/questions/7030699/oracle-sql-update-a-table-with-data-from-another-table

Oracle SQL: Update a table with data from another table

This is called a correlated update. UPDATE table1 t1 SET (name, desc) = (SELECT t2.name, t2.desc FROM table2 t2 WHERE t1.id = t2.id) WHERE ...

確定！ 回上一頁

查詢 「Oracle UPDATE SELECT」的人也找了：

  1. oracle update select用法
    2.
  2. oracle update多筆
    3.
  3. oracle update語法
    4.
  4. Oracle UPDATE SELECT
    5.
  5. oracle update多欄位
    6.
  6. Oracle update join
    7.
  7. Oracle update subquery
    8.
  8. oracle update兩個table
    9.