Oracle 11g Update statement with Error ORA-00904

The extra join seems unnecessary. Why not just use this simpler version?

UPDATE Appliance
    SET Appliance.IdApplianceType =
        (SELECT AT.id
         FROM ApplianceType AT
         WHERE UPPER(Appliance.typeName) = UPPER(AT.name)
        );

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top