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 :
"LEC=XO, BTN=333-666-1111
Sourcebook and VoIP Discovery available.
Area= CapitalMetro, District= Greensboro"

I just need the info after Area=. so in this case CapitalMetro.
Please advise/assist
thanks,
Mike