行与列的倒数

请尝试UnPIVOT：

SELECt substr(kind,2,1) AS kind,"value" FROM (        SELECt        5 AS l0,        2 AS l1,        3 AS l2,        4 AS l3    FROM dual)temp unpivot include NULLS ("value" FOR kind IN (l0, l1 , l2, l3));

反之：

 SELECt *    FROM  (      SELECt Kind,  max(Value) Value      FROM table       GROUP BY Kind ) PIVOT ( max(Value) FOR Kind IN (L0, L1, L2, L3) );

假设您实际上有一个要查询的表。