Welcome to WebmasterServe!

FREE TO JOIN! Join us now to engage in informative and friendly discussions about Webmastering, SEO, SEM, Internet Marketing, Programming, Graphic Design, Online Jobs and more. What are you waiting for? Ready to join our friendly community? It takes just one minute to register.

Dismiss Notice

Join WebmasterServe Forums 
Join the discussion! Have a better idea or an opinion? It takes just one minute to register Click Here to Join

Help Me/Question Pivoting Of Data

Discussion in 'Database Management' started by krishatg, Jan 29, 2016.

  1. krishatg

    Yellow Belt

    Joined:
    Jan 16, 2016
    Messages:
    240
    Ratings:
    +14 / -0
    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.
     
  2. Oldwriter

    Yellow Belt

    Joined:
    Dec 10, 2015
    Messages:
    64
    Ratings:
    +28 / -0
    Hello dear @krishatg, what's the database engine + target programming language?
     
  3. krishatg

    Yellow Belt

    Joined:
    Jan 16, 2016
    Messages:
    240
    Ratings:
    +14 / -0
    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.
     

Share This Page