can you help me please with that
SQL Error: ORA-00001: unique constraint (Joseph.CYCLES_UK1) violated
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
my code is :
UPDATE cycles
SET partner_code = (SELECT partner_code
FROM PARTNERS
WHERE partners.DEFAULT_CYCLE_CODE = cycles.CYCLE_CODE
)
WHERE partner_code is null;
please help i am newbie