<div>
regexp_substr(yourstring,'<wbr />[^ ]+$')<br />
<br />
<br />
for example...<br />
<br />
<br />
select regexp_substr('Administrat<wbr />ion Main Boston','[^ ]+$') from dual
</div>


regexp_substr(yourstring,'[^ ]+$')


for example...


select regexp_substr('Administration Main Boston','[^ ]+$') from dual

<div>
substr/instr method:<br />
select substr('administration main boston', instr('administration main boston',' ',-1)+1) from dual;
</div>


substr/instr method:
select substr('administration main boston', instr('administration main boston',' ',-1)+1) from dual;

<div>
Thank you both so much for the function.<br />
One more question: what if I need to extract 2nd right most word? Just realized, I need to do this for some conditions. Is there a quick way to extract 2nd right most word?<br />
<br />
&quot;Administration Main Boston Office&quot; = &quot;Boston&quot;<br />
<br />
Thank you.
</div>


Thank you both so much for the function.
One more question: what if I need to extract 2nd right most word? Just realized, I need to do this for some conditions. Is there a quick way to extract 2nd right most word?

"Administration Main Boston Office" = "Boston"

Thank you.

<div>
another interesting variation for 2nd last word<br />
<br />
reverse(regexp_substr(reve<wbr />rse('Admin<wbr />istration Main Boston Office'),'[^ ]+',1,2))
</div>


another interesting variation for 2nd last word

reverse(regexp_substr(reverse('Administration Main Boston Office'),'[^ ]+',1,2))

<div>
you should awared a split with slightwv as well for answering the original question
</div>


you should awared a split with slightwv as well for answering the original question

<div>
<div class="content wysiwyg-content">
Hi, I need to extract the right-most word from a field that could have multiple spaces. Example: &quot;Administration Main Boston&quot; = &quot;Boston&quot;<br />
<br />
Thanks.
</div>
</div>


Hi, I need to extract the right-most word from a field that could have multiple spaces. Example: "Administration Main Boston" = "Boston"

Thanks.

Oracle SQL - Extract rightmost word in string

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.