how to return the last word in a string

[rmgirma]

Hello,
I needed to return the first and last word in any given string. Words are separated by a single space. I was able to return the first word but need help for returning the last word.

The desired output is as follows:
Str1                    First        Last
-----------------       ---------    --------- 
Blue sky                Blue         sky
red 1. green            red          green
The color is blue       The          blue 
My name is John         My           John


select 
substr(Str1,1,instr(Str1, ' ')-1) First,
substr(Str1,-1,instr(substr(Str1,-1),' ')+1) Last
from Table1;

The above sql statement output is as follows:
Str1                    First        Last
-----------------       ---------    --------- 
Blue sky                Blue         y
red 1. green            red          n
The color is blue       The          e 
My name is John         My           n

it returns the last character of the word and not the whole word.
Thanks for your help !

[DaPi]

Untested:
substr(Str1, instr(Str1, ' ', -1)+1) Last

[rmgirma]

That did it !
Thanks for your help DaPi !