Skip to content
Advertisement

Tag: composite-primary-key

Oracle SQL Unique Constraint Violated

I need to create tables and input values. All but two rows when inserted give me an error, Unique Constraint Violated. The last row in DEPT_LOCATIONS table and the second to the last row in DEPENDENT table. I’m not sure why these rows aren’t being added because other rows in the same table are. Here’s my code so far: The

Advertisement