Αποτελέσματα Αναζήτησης
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'
19 Φεβ 2015 · SELECT * FROM PERSON p. INNER JOIN CONTACT on CONTACT.PERSON_ID = p.PERSON_ID. WHERE CONTACT.CURRENT_YEAR_ID = (. SELECT CURRENT_YEAR_ID FROM CURRENT_YEAR WHERE DEFAULT_YEAR = 1. ); Tried another variant : UPDATE CONTACT. SET CONTACT.PHONE = p.PHONE, CONTACT.FAX = p.FAX.
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 ...
So I use "update (select tbl1 join tbl2...)" command. Both tables have primary keys defined and I thought that my join was uniquely identifying rows, but I'm still getting "ORA-01779: cannot modify a column which maps to a non key-preserved table".
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.
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.
