Oracle ORA-00907: отсутствует правая скобка
create table listener
(
id_listener int generated by default as identity,
constraint pk_listener primary key (id_listener),
first_name_listener varchar(128) not null,
second_name_listener varchar(128) not null,
third_name_listener varchar(128) null default ('-'),
series_passport_listener varchar(256) not null,
constraint ch_series_passport_listener check(regexp_like(series_passport_listener, '[0-9]{2}[0-9]{2}')),
num_passport_listener varchar(256) not null,
constraint ch_num_passport_listener check(regexp_like(num_passport_listener, '[0-9]{6}')),
issued_by varchar(256) not null,
num_phone_listener varchar(256) not null,
constraint ch_num_phone_listener check(regexp_like(num_phone_listener, '%7[0-9]{10}'))
);
Источник: Stack Overflow на русском