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.