代码如下:
SQL> select * from pp;
GP ITEMNO ITEMNAME ITEMVALUE
----- -------- -------- ----------
Glass Glass001 X1 1
Glass Glass002 X1 0
Glass Glass003 X1 1
Glass Glass004 X1 1
Glass Glass005 X1 1
Glass Glass006 X1 0
Glass Glass007 X1 1
Glass Glass008 X1 1
Glass Glass009 X1 1
Glass Glass010 X1 0
Glass Glass001 X2 1
Glass Glass002 X2 0
Glass Glass003 X2 1
Glass Glass004 X2 1
Glass Glass005 X2 1
Glass Glass006 X2 0
Glass Glass007 X2 1
Glass Glass008 X2 1
Glass Glass009 X2