Αποτελέσματα Αναζήτησης
15 Μαρ 2010 · You can do this: UPDATE table1 SET table1.value = (SELECT table2.CODE. FROM table2 . WHERE table1.value = table2.DESC) WHERE table1.UPDATETYPE='blah'
Here is an example: UPDATE items,month SET items.price=month.price WHERE items.id=month.id; The preceding example shows an inner join that uses the comma operator, but multiple-table UPDATE statements can use any type of join permitted in SELECT statements, such as LEFT JOIN.
19 Φεβ 2015 · For example: UPDATE CONTACT C SET (C.PHONE, C.FAX) = ( SELECT P.PHONE, P.FAX FROM PERSON P WHERE P.PERSON_ID = C.PERSON_ID ) WHERE C.CURRENT_YEAR_ID = ( SELECT CURRENT_YEAR_ID FROM CURRENT_YEAR WHERE DEFAULT_YEAR = 1 ); (You'll have to check my logic, because I'm not entirely clear on your relationships.)
24 Μαΐ 2017 · Usually, when you need to join multiple tables in an UPDATE, MERGE is the solution.
First, specify the table that you want to update after the UPDATE keyword (T1). Second, use either INNER JOIN or LEFT JOIN and a join predicate. The JOIN clause must appear right after the UPDATE clause. Third, assign new values to the columns of the T1 table that you want to update data.
4 Αυγ 2023 · Direct join syntax is unsupported in Oracle Database; use a correlated subquery to fetch the values instead. For example: update nashvillehousing a set propertyaddress = ( select nvl2(a.propertyaddress, b.propertyaddress,b.propertyaddress) from nashvillehousing b where a.parcelid = b.parcelid and a.uniqueid_ != b.uniqueid_ ) where a ...
21 Νοε 2016 · In ORACLE A simple way for update joined table is based on the use the the joined select as a table . UPDATE ( SELECT TBL_TEST2.NAME AS OLD_VALUE FROM TBL_TEST2 INNER JOIN TBL_TEST1 ON TBL_TEST2.DISTRICT = TBL_TEST1.DISTRICT WHERE TBL_TEST2.DISTRICT = '1' ) T SET T.OLD_VALUE = 'DONE' ;
