Oracle 11g Release 2

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

CREATE TABLE TABLE1( NO NUMBER(3) NOT NULL, NAME VARCHAR2(5) NOT NULL);
CREATE UNIQUE INDEX TX ON TABLE1(NO,NAME);
begin
  dbms_errlog.create_error_log (
    dml_table_name     => 'TABLE1'
  );
end;
/
1 rows affected

INSERT INTO TABLE1 VALUES(101, 'JOHN');
1 rows affected

INSERT INTO TABLE1 VALUES(102, 'MORN');
1 rows affected

INSERT INTO TABLE1 VALUES(103, 'TONY') LOG ERRORS REJECT LIMIT UNLIMITED;
1 rows affected

INSERT INTO TABLE1 VALUES(103, 'TONY') LOG ERRORS REJECT LIMIT UNLIMITED;
INSERT INTO TABLE1 VALUES(103, 'RONY') LOG ERRORS REJECT LIMIT UNLIMITED;
1 rows affected

SELECT * FROM table1;


NO
NAME


101
JOHN

102
MORN

103
RONY

103
TONY


SELECT * FROM ERR$_TABLE1;


ORA_ERR_NUMBER$
ORA_ERR_MESG$
ORA_ERR_ROWID$
ORA_ERR_OPTYP$
ORA_ERR_TAG$
NO
NAME


1
ORA-00001: unique constraint (FIDDLE_TAXEGGNAZTFZWUNUZXOL.TX) violated

null
I
null
103
TONY