By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;
| BANNER | BANNER_FULL | BANNER_LEGACY | CON_ID |
|---|---|---|---|
| Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production | Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0 |
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production | 0 |
create table t23 (txt varchar2(16));
insert all
into t23 values ('A25')
into t23 values ('AB567')
into t23 values ('ABC999')
into t23 values ('AB')
into t23 values ('A12A532A')
select * from dual;
5 rows affected
select * from t23
where regexp_like(txt, '^[A-Z]{1,2}[0-9]+$')
| TXT |
|---|
| A25 |
| AB567 |