select decode(substr(FZPRIVIDSTR,0 ,instr(FZPRIVIDSTR,',')-1),'','1','0')  as  col1, decode(substr(FZPRIVIDSTR,5 ,3),'','1','0')  as col2 ,

decode(substr(FZPRIVIDSTR,9 ,3),'','1','0')  as col3,decode(substr(FZPRIVIDSTR,13 ,3),'','1','0')  as col4

        from users