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