oracle行转列、列转行查询语句

1、行转列

select * from (select A.datekey, A.Dateyear,A.Datemonth from F_JZB_WLAQXMSL A) pivot (sum(A.XMSL) for A.XMJD in ('1' 规划, '2'立项, '3'建设, '4'验收,'5'结项,'6'运维));

2、列转行

SELECT * FROM F_JZB_GYSPPM UNPIVOT(
"NIANYUE "
FOR"项目"
IN (
Dppmzb，
Tlzs，
Zxbls，
Llbls，
Dppm))