By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test (
email varchar2(100),
phone varchar2(20),
CONSTRAINT E_GO_APP_USERS_UK1 UNIQUE (email),
CONSTRAINT E_GO_APP_USERS_UK2 UNIQUE (phone));
insert into test values ('E1', 'P1');
1 rows affected
insert into test values ('E2', 'P1');
ORA-00001: unique constraint (FIDDLE_EZCONYUAWJDQFPAUSNPI.E_GO_APP_USERS_UK2) violated
select column_name from user_cons_columns where constraint_name = 'E_GO_APP_USERS_UK2'
| COLUMN_NAME |
|---|
| PHONE |