combining fields (name, surname etc.)

[TjS]

I have a (i hope) simple question.

In our db (oracle) there are a couple of fields for making a name;
I will give an example

field1 = Shakespeare
field2 = William
Field3 = WSX
field4 = Bill
Field5 = Von

Combining has to be as follows:
William S Von Shakespeare

Thanks in advance

if you recognize names mentioned here above, it's just a coïncidence

 

[Nbrown]

You need the CONCAT command (concatenate) but I'm not an Oracle man myself so can't give you the specific syntax to use