oracle 行转列

select * from (SELECT REGION,STATION,FR_NAME_C,FR_NAME_E,TRAVEL_DATE 

from BE_AUDIT_TRAVELPLAN) pivot (count(*) for TRAVEL_DATE in (date'2018-04-03',date'2018-04-04',date'2018-04-05',date'2018-04-06')) 

只支持数字格式

SELECT ROW_ID,STATION,FR_NAME_C,FR_NAME_E,
case when TRAVEL_DATE= (date'2018-04-03') then TRAVEL_SITE end  tral0, (date'2018-04-03') as adress0,
case when TRAVEL_DATE= (date'2018-04-04') then TRAVEL_SITE end  tral1, (date'2018-04-03') as adress1,
case when TRAVEL_DATE= (date'2018-04-05') then TRAVEL_SITE end  tral2, (date'2018-04-05') as adress2

from BE_AUDIT_TRAVELPLAN

case when 可为汉字