SQL> How do I show just the second word in each vendor name?

[Jessica]

If there is one; otherwise just blanks/

using sql developer