Write a query for split one column to multiple columns

I have a source table with one column of 15 characters and I want output like divide the 15 chars column into multiple of 3 columns like every column 5 chars
source empnoorderprdct target empno order prdct
  • Interview Candidate
  • 2
  • 12031

Showing Answers 1 - 2 of 2 Answers

Divya

  • Jun 5th, 2017
 

You can use Substring function to split the column values to 3 columns

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions