UPDATE XXWSH_EQUIPMENT_CODE xec
SET xec.EQUIPMENT_CODE = :XXWSH_EQUIPMENT_CODE.EQUIPMENT_CODE
,xec.EQUIPMENT_NAME = :XXWSH_EQUIPMENT_CODE.EQUIPMENT_NAME
,xec.START_DATE = :XXWSH_EQUIPMENT_CODE.START_DATE
,xec.END_DATE = :XXWSH_EQUIPMENT_CODE.END_DATE
,xec.ENABLED_FLAG = :XXWSH_EQUIPMENT_CODE.ENABLED_FLAG
,xec.CREATED_BY = :XXWSH_EQUIPMENT_CODE.CREATED_BY
,xec.CREATION_DATE = :XXWSH_EQUIPMENT_CODE.CREATION_DATE
,xec.LAST_UPDATE_BY = :XXWSH_EQUIPMENT_CODE.LAST_UPDATE_BY
,xec.LAST_UPDATE_DATE = SYSDATE
,xec.LAST_UPDATE_LOGIN = :XXWSH_EQUIPMENT_CODE.LAST_UPDATE_LOGIN
WHERE xec.EQUIPMENT_CODE = :XXWSH_EQUIPMENT_CODE.EQUIPMENT_CODE;
XXWSH_EQUIPMENT_CODE 테이블에 UNIQUE KEY는 EQUIPMENT_CODE 입니다.
수정하려고 하는데 다른 칼럼들은 수정이되는데 EQUIPMENT_CODE값만 수정이 안되네요... UNIQUE KEY하고 관련있는거같은데 조건절을 바꿔야하나요??