Αποτελέσματα Αναζήτησης
15 Μαρ 2010 · UPDATE (SELECT T.FIELD A, S.FIELD B FROM TABLE_T T INNER JOIN TABLE_S S ON T.ID = S.ID) SET B = A; A and B are alias fields, you do not need to point the table.
19 Φεβ 2015 · UPDATE CONTACT. SET CONTACT.PHONE = p.PHONE, CONTACT.FAX = p.FAX. FROM PERSON as p. WHERE p.PERSON_ID = CONTACT.PERSON_ID. AND CONTACT.CURRENT_YEAR_ID = ( SELECT CURRENT_YEAR_ID FROM CURRENT_YEAR WHERE DEFAULT_YEAR = 1. ); Another one : UPDATE CONTACT. (SELECT PERSON.PHONE as PHONE, PERSON.FAX as FAX. FROM PERSON.
24 Μαΐ 2017 · Usually, when you need to join multiple tables in an UPDATE, MERGE is the solution. merge into address a1 using ( select p.address_fk, ta2.tempaddress1 from premise p join account ac on (ac.id = p.account_fk) join tempaddresstable ta2 on (ac.ext_ref = ta2.tempextref) ) ta1 on (a1.id = ta1.address_fk) when matched then update set a1.address1 ...
22 Νοε 2011 · Here is my scenario: I am trying to update multiple fields on specific records in a table based on other rows in the same table. I am sure that there is a one-to one match in my join, but I still get that error.
27 Δεκ 2023 · While using update with join operation in Oracle, you may encounter the following errors: ORA-01427: single-row subquery returns more than one row: This error occurs when the subquery used in the update operation returns more than one row for a row in the updated table.
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 ...
16 Ιουλ 2012 · you could use a global temporary table with a primary key on the join column, insert the data from S into this table where fld='a' and then update the join.
