sql04

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