Help Me/Question Pivoting Of Data

krishatg

Yellow Belt
I want to split the data of one field in one table into 3 fields in the second table using SQL query. Can some help me to do that.
For example:
Name field in the first table contains value JOHN Chang Hu
I want to split it to first , middle and last name (three different fields) in second table.

Thanks in advance.
 

krishatg

Yellow Belt
I am using oracle 10g. I want to do this with SQL query. Actually i am trying this with SAP BODS. That is also work on SQL Scripts only.
 
Top