Oracle SQL - A violation of a primary key constraint in INSERT statement

  1. HOME
  2. Oracle SQL
  3. Data Change Command
  4. INSERT Command

Introduction

The following example shows a violation of a primary key constraint; department 10 already exists. 


insert into departments(dname,location,deptno)
values('CATERING','ORLANDO', 10);

insert into departments(dname,location,deptno)
*
ERROR at line 1:
ORA-00001: unique constraint (BOOK.D_PK) violated

Related Topic