Split without delimiter based on position
936666Oct 19 2012 — edited Oct 24 2012Hi,
I am having a query i need to split the query based on the position i specify
Say
string is 123456789101112
am having position as 1,1,2,5,4,2
i need as
1
2
34
56789
1011
12
I need to insert this in to my table
create test table (col1 number(10),col2 number(10),col3 number(10),col4 number(10),col5 number(10),col6 number(10));
col1,col2,col3,col4,col5,col6
1,2,34,56789,1011,12
Thanks