SQL & PL/SQL

I've a column in which I both have adress and housenumber. How can I seperate these from each other?
The patters is always like :
Street A number1
B Street numberb2

This means that I alyways need the last part of the adress in my example to determine the number:
I should get from above two rows for address:
Street A
B Street


AND for numbers:
number1
numberb2

Any help will be highly appreciated.

Thanks in advance!