Search results
For primary key backed TABLEA you may use simple extension of your original query (adding a WHERE predicate): update TABLEB set VALUE = ( select VALUE from TableA where ID = '1' and TABLEB.AS_OF_DATE < TABLEA.ADD_TIME ) where TABLEB.AS_OF_DATE < (select ADD_TIME from TABLEA where ID = '1')
1 maj 2012 · Oracle lets you update the results of a SELECT statement. UPDATE (<SELECT Statement>) SET <column_name> = <value>. WHERE <column_name> <condition> <value>; I suppose that this could be used for updating columns in one table based on the value of a matching row in another table.
UPDATE table1 t1 SET (name, desc) = (SELECT t2.name, t2.desc FROM table2 t2 WHERE t1.id = t2.id) WHERE EXISTS ( SELECT 1 FROM table2 t2 WHERE t1.id = t2.id ) Assuming the join results in a key-preserved view, you could also
This Oracle tutorial explains how to use the Oracle UPDATE statement with syntax, examples, and practice exercises. The Oracle UPDATE statement is used to update existing records in a table in an Oracle database. There are 2 syntaxes for an update query in Oracle.
UPDATE dest_tab tt SET (tt.code, tt.description) = (SELECT st.code, st.description FROM source_tab st WHERE st.id = tt.id) WHERE EXISTS (SELECT 1 FROM source_tab WHERE id = tt.id); 5000 rows updated. SQL> SELECT COUNT(*) FROM dest_tab WHERE description LIKE 'Updated%'; COUNT(*) ----- 5000 SQL> ROLLBACK;
This tutorial shows you how to use Oracle UPDATE statement to change existing values in a table. It also provides some practical examples of updating data.
Specify the name of the table, view, materialized view, or the columns returned by a subquery to be updated. Issuing an UPDATE statement against a table fires any UPDATE triggers associated with the table. If you specify view, then the database updates the base table of the view.
