Thanks for the question, Vinay.
Asked: March 06, 2018 - 9:21 pm UTC
Last updated: March 08, 2018 - 2:59 am UTC
Version: 11g
Viewed 1000+ times
with rws as ( select 'somestreet 22a' str from dual union all select 'oldstreet 5d' str from dual union all select 'othernewtreet 134B' from dual ) select regexp_replace(str, '([[:digit:]]+)([[:alpha:]]+)', '\1 \2') new_str from rws; NEW_STR somestreet 22 a oldstreet 5 d othernewtreet 134 B
Vinay, March 07, 2018 - 7:02 pm UTC
The Oracle documentation contains a complete SQL reference.