Oracle 21c

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

CREATE TABLE sf_group (group_name) AS
SELECT '德州分公司.禹城分公司' FROM DUAL UNION ALL
SELECT '德州分公司.齐河分公司' FROM DUAL UNION ALL
SELECT '德州分公司.综合部'     FROM DUAL UNION ALL
SELECT '德州分公司.集团客户部' FROM DUAL;
4 rows affected

SELECT group_name,
       DUMP(group_name, 1010)
FROM   sf_group


GROUP_NAME
DUMP(GROUP_NAME,1010)


德州分公司.禹城分公司
Typ=1 Len=31 CharacterSet=AL32UTF8: 229,190,183,229,183,158,229,136,134,229,133,172,229,143,184,46,231,166,185,229,159,142,229,136,134,229,133,172,229,143,184

德州分公司.齐河分公司
Typ=1 Len=31 CharacterSet=AL32UTF8: 229,190,183,229,183,158,229,136,134,229,133,172,229,143,184,46,233,189,144,230,178,179,229,136,134,229,133,172,229,143,184

德州分公司.综合部
Typ=1 Len=25 CharacterSet=AL32UTF8: 229,190,183,229,183,158,229,136,134,229,133,172,229,143,184,46,231,187,188,229,144,136,233,131,168

德州分公司.集团客户部
Typ=1 Len=31 CharacterSet=AL32UTF8: 229,190,183,229,183,158,229,136,134,229,133,172,229,143,184,46,233,155,134,229,155,162,229,174,162,230,136,183,233,131,168


select *
FROM   SF_GROUP T
where  regexp_like(t.group_name,
                   '^德州分公司\..*公司$');


GROUP_NAME


德州分公司.禹城分公司

德州分公司.齐河分公司


select *
FROM   SF_GROUP T
where  regexp_like(t.group_name,
                   '^德州分公司\.(['
                   || unistr('\4e00')
                   || '-'
                   || unistr('\9fa5')
                   || ']*)公司$');


GROUP_NAME


德州分公司.禹城分公司

德州分公司.齐河分公司


select *
FROM SF_GROUP T
where regexp_like(t.group_name,
                 '^德州分公司\.([\u4e00-\u9fa5]*)公司$');

GROUP_NAME	DUMP(GROUP_NAME,1010)
德州分公司.禹城分公司	Typ=1 Len=31 CharacterSet=AL32UTF8: 229,190,183,229,183,158,229,136,134,229,133,172,229,143,184,46,231,166,185,229,159,142,229,136,134,229,133,172,229,143,184
德州分公司.齐河分公司	Typ=1 Len=31 CharacterSet=AL32UTF8: 229,190,183,229,183,158,229,136,134,229,133,172,229,143,184,46,233,189,144,230,178,179,229,136,134,229,133,172,229,143,184
德州分公司.综合部	Typ=1 Len=25 CharacterSet=AL32UTF8: 229,190,183,229,183,158,229,136,134,229,133,172,229,143,184,46,231,187,188,229,144,136,233,131,168
德州分公司.集团客户部	Typ=1 Len=31 CharacterSet=AL32UTF8: 229,190,183,229,183,158,229,136,134,229,133,172,229,143,184,46,233,155,134,229,155,162,229,174,162,230,136,183,233,131,168