By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table a (address VARCHAR2(56));
insert into a (address) values ('ביאליק 23');
1 rows affected
insert into a (address) values ('ADDR 78 SS');
1 rows affected
SELECT
REGEXP_REPLACE(address, '(\d+)', REVERSE(REGEXP_SUBSTR(address, '\d+'))) AS reserved_address
FROM
a;
| RESERVED_ADDRESS |
|---|
| ביאליק 32 |
| ADDR 87 SS |