By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table test (a int, b int, c int);
create unique index idx_test on test(a, b, c);
insert into test values (1,1,null);
1 rows affected
insert into test values (1,1,null);
ORA-00001: unique constraint (FIDDLE_KYXGIADRYFGACBQEUUXE.IDX_TEST) violated
select *
from test;
| A | B | C |
|---|---|---|
| 1 | 1 | null |