CODEWITHSUNDEEP
sqloracle-database
Abhichetan chauhan
Abhichetan chauhan

Reputation: 1

I want to convert 1 column into multiple columns

If source table t1 is this:

| col1    |
+---------+
| 2-3-4-5 |
| 6-7     |
| 8       |
| 9       |

then output should be in 4 columns:-

| col1 | col2 | col3 | col4 |
+------+------+------+------+
| 2    |  3   |  4   |  5   |
| 6    |  7   |      |      |
| 8    |      |      |      |
| 9    |      |      |      |

Upvotes: 0

Views: 41

Answers (1)

Anil Bhaskar
Anil Bhaskar

Reputation: 3978

It is not the direct answer to the question still, I would like to make a note. If you can leverage ETL tools, it will really be easier and will give you lot of control over the transformation of data. You can have a different kind of data in source eg. 2-3-4, 5, 6-7 or 1 2 3, 45 1, 21 10 (or anything in that matter) and transform it.

Upvotes: 2

Related Questions