Layer conversion example table TTT has three fields SEQ - sequence jcxm - check item zhi - value
The data is as follows: SEQ JCXM zhi -------------- -------- 11 1 0.5011 2 0.2113 3 0.2512 1 0.2412 2 0.3012 3 0.22
Move the row value when implementing the function to create a view
Create View V_View1ASselect Seq, SUM (Decode (JCXM, 1, ZHI)) Detection items 1, SUM (Decode (JCDE (JCDE (JCDE (JCDE (JCDE (JCXM, 3, ZHI)) Test Item 3 from TTTGROUP BY SEQ;
Number detection item 1 Test item 2 Test item 311 0.50 0.21 0.2512 0.24 0.30 0.22
An example of an Oracle for loop:
DECLE INT_S NUMBER; INT_E NUMBER; BegInselect TO_NUMBER (S), TO_NUMBER (E) INTO INT_S, INT_E from Table1; For i Iin INT_S .. INT_E LOOPINT_S: = INT_S 1; End Loop;
