I have a column in a table that contains a clob. i need to extract data from the clob that starts with "Area=". So for example the clob looks like :
Sourcebook and VoIP Discovery available.
Area= CapitalMetro, District= Greensboro"
I just need the info after Area=. so in this case CapitalMetro.