oracle databaseMerging of regex

oracle database - Merging of regex and replace - Stack Overflow
I am using Oracle, but my question is general.I have a text field like below:25:3500011-01-3 or:25:7
oracle databaseMerging of regex and replaceStack Overflow
admin13小时前
30