Oracle regexp finding text after a specific string
How do I return the text between the single quotes in an Oracle VARCHAR field.
The field contains the text pattern below. I need to find the string PTYPE=> and then grab the text between the quotes. There is text in the source column before and after the P_TYPE=>
This is record one containing P_TYPE=>’This is the piece I need’ plus a bunch of text after
This is record two containing P_TYPE=>’This is the next record ‘ plus more text
I want to return the strings:
This is the piece I need
This is the next record
Read more here: Source link
