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
select * from a
| ADDRESS |
|---|
| בליק 23 |
SELECT SUBSTR(address, 0, INSTR(address, ' ') ) || REVERSE(SUBSTR(address, INSTR(address, ' ') + 1)) as reversed_address
FROM a;
| REVERSED_ADDRESS |
|---|
| בליק 32 |