var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: spliting column values based on space
I have a column t1 in table with varchar2(50);
I have to split the column values based on the space.
so that Ani , Amber , John and Andy comes in one column and Hath,Cr,Mojo and Green comes into second.
please advice !!!
Use SUBSTR and INSTR functions to separate those values.
SUBSTR(t1,1,INSTR(t1,',',1) -1) it gives me the first part like Ani Amber etc.
Not able to figure out how to get the second part i.e Hath,Cr,Mojo etc .