Unique constraint violated in SQL

I am trying to add data to my SQL database, and when I enter the following code:

INSERT INTO EMPLOYEES 
VALUES('100','STEVEN','King','sking@yahoo.com','PSEUDO',
to_date('17-JAN-87','dd-mm-yy'),'AD_VP',24000,0.45,90);

I get the following error:

ERROR at line 1:
ORA-00001: unique constraint (ODEHat01.SYS_C00292486) Violated

I am not sure what I am doing wrong, because when I describe my table ( desc employees;), it shows that I have 10 fields and I'm trying to enter data in ten fields. Any help would be greatly appreciated, so I can enter data into the table of my staff. Thanks.

+4
source share
1 answer

This means that the table has a unique index in one of its fields and that you are trying to insert a value that already exists.

, , "100".

+9

All Articles