for oracle中pivot_Oracle PIVOT 行转列方法

为实现页面效果，可使用decode方法，SQL片段如下

DECODE(C1,1 ,'true','false') AS C1 ，DECODE(C2,2 ,'true','false') AS C2 ，DECODE(C3,3 ,'true','false') AS C3 ，DECODE(C4,4 ,'true','false') AS C4 ，DECODE(C6,6 ,'true','false') AS C6 ，DECODE(C7,7 ,'true','false') AS C7 ，DECODE(C8,8 ,'true','false') AS C8 ，DECODE(C9,9 ,'true','false') AS C9 ，DECODE(C10,10 ,'true','false') AS C10，DECODE(C11,11 ,'true','false') AS C11 ，DECODE(C12,12 ,'true','false') AS C12

这样，检索后的结果就是true 或 false ，然后将检索结果赋给checkbox，就能按要求显示了。