Oracle列转行unpivot

unpivot可以实现列转行,所转的列的字段类型必须一致

 

SELECT STU_NAME, TERM, COURSE_MARK

  FROM (SELECT '罗飞' STU_NAME,

               '2001-2002' TERM,

               '90' 微积分,

               '88' 线性代数,

               '85' 数据结构,

               '70' 操作系统

          FROM DUAL) UNPIVOT(COURSE_MARK FOR TYPE IN(微积分,

                                                     线性代数,

                                                     数据结构,

                                                     操作系统))