Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE test (
  id INT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
  data VARCHAR(255)
);
INSERT INTO test(id,data) VALUES(3,'something');
1 rows affected

INSERT INTO test(id,data) VALUES(6,'something else');
1 rows affected

INSERT INTO test(data) VALUES('whatever');
1 rows affected

INSERT INTO test(data) VALUES('stuff');
1 rows affected

INSERT INTO test(data) VALUES('etc');
ORA-00001: unique constraint (FIDDLE_HVGJQXDUFVIKHWSPXECI.SYS_C00190779) violated

SELECT * FROM test;


ID
DATA


3
something

6
something else

1
whatever

2
stuff