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.
source
share