Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Extract value from a string

user11334489Sep 19 2022 — edited Sep 19 2022

Hi Team,
I am using Oracle 19c database .
Strings
Hello test java (0003-1765-00)
Hello JavaScript test lang 8765-6577-18
test oracle 18549-658-98
test testing oracle test 87659-2369-2

Need to extract the values as below from the above strings
0003-1765-00
8765-6577-18
18549-658-98
87659-2369-2
How to do it. Can you please share the query to get this.
Thanks in advance.
Regards,
Abu

Comments
Post Details
Added on Sep 19 2022
13 comments
425 views