Create table Patient( Fullname varchar(55) not null, Phone varchar(13) not null, Birthday date, DataMetting date, Notice varchar(1000), primary key(Fullname,Phone) ); Create table Specialist( Fullname varchar(55) not null, Phone varchar(13) not null, Birthday date, Education varchar(1000), DateToWork date, primary key(Fullname,Phone) ); insert into SPECIALIST(PHONE , FULLNAME , EDUCATION, BIRTHDAY) values ('011','A','vuz1','1996-AUG-24'); insert into SPECIALIST(PHONE , FULLNAME , EDUCATION) values ('323','B','vuz2');

An error

 Error report - ORA-00001: unique constraint (SYSTEM.SYS_C0011799) violated

Its translation is clear, but the essence is not much. And another problem, why is not the date added. Oracle DBMS.

Thank !

  • Table Specialist before INSERT was empty? - Vladislav Khapin
  • Yes, before the addition, it was empty, but I created it above - Vlad
  • On an empty table, these two inserts occur (just checked). True, the first insert has to be corrected, because you have a field of type a date and you cannot insert a string there. The question arises where do you insert the lines if the first insert should lead to an error - Mike
  • one
    I deleted it)) and inserted it without it, I don’t know how to add the date, and through to_date I tried, and tried a bunch of different expressions. - Vlad
  • one
    @ Vlad, even so? TO_DATE ('1996-AUG-24', 'RRRR-MON-DD') - Vladislav Khapin

0