oracle中的列转行例子，亲测，网上抄的备忘

SELECT COURSE_MARK
  FROM (SELECT '罗飞' STU_NAME,
               '2001-2002' TERM,
               '90' 微积分,
               '88' 线性代数,
               '85' 数据结构,
               '70' 操作系统
          FROM DUAL) UNPIVOT(COURSE_MARK FOR TYPE IN(
                                                     微积分,
                                                     线性代数,
                                                     数据结构,
                                                     操作系统))