Need an Oracle Regular Expression to pull out FRENCH from this pattern
RECEIVED A LANGUAGE STUDY MINOR IN FRENCH, which is embedded in this sample string. Assume the string ends in a period(.)
Sample full string.
ATTENDED UGA 1ST SEM/FALL 1997-98 AS AN EXCHANGE STUDENT.
RECEIVED A LANGUAGE STUDY MINOR IN FRENCH. CAPSTONE SCHOLAR PROJECT - 'THE EFFECTS OF FIBER REINFORCED PLASTIC COMPOSITES ON THE DUCTILITY OF RETROFITTED CONCRETE BEAMS'
I tried but can't follow the REGEXP_SUBSTR pages such as this - it's all too cryptic to me, and I hardly use this.