MySQL Forums
Forum List  »  Newbie

Re: Need help with basic INSERT statements not working!
Posted by: Phillip Ward
Date: July 14, 2022 02:12AM

Quote

I use Oracle Live SQL

Wrong forum.
Whilst Oracle [Corporation] own both Oracle Database and MySQL, any similarity ends there.

Quote

I am getting an error when loading dummy INSERT values for tables that have a PK/FK combination (error code below) ...
ORA-00001: unique constraint (SQL_MXCHETYAKNOPXXVKCEVUIDYRD.EMPLOYEE_SKILLS_PK) violated ORA-06512: at "SYS.DBMS_SQL", line 1721

The unique constraint is there to prevent you adding the same combination of values more than once in a table.
From its name, I'm guessing that this constraint is the Primary Key constraint for that Employee Skills table.
This entry ...
INSERT INTO EMPLOYEE_SKILLS VALUES ('390 05 4489', 'LAB');
--^^error
... already exists in the table.

Short answer - don't try to insert it again.

Where is this data coming from?

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
Re: Need help with basic INSERT statements not working!
July 14, 2022 02:12AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.