Skip to Main Content
Forums

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!

Using REGEXP_SUBSTR to extract all specific characters

twinklin_girlNov 20 2018 — edited Nov 29 2018

Hello ,

I need to extract all characters after style ,i.e. AD-50 TSV , and SKU ,i.e.,19882164 from string below :

PO: 011899/19882164 SKU 19882164 / MDA No:  / Style: AD-50 TSV /

Please help .

Thanks.
This post has been answered by Gaz in Oz on Nov 20 2018
Jump to Answer
Comments
Post Details
Added on Nov 20 2018
11 comments
3,435 views