SQL> with t as ( select  'Mrs xxxxxx yyyyy' str from dual )
  2  select
  3    substr(str,1,instr(str,' ')-1) title,
  4    substr(str,instr(str,' ')+1,instr(str,' ',1,2)-instr(str,' ',1,1)-1) forename,
  5    substr(str,instr(str,' ',1,2)+1) surname
  6  from t;

TIT FORENA SURNA
--- ------ -----
Mrs xxxxxx yyyyy