ORAClE sql如何实现行转列？

如果“站名”、“条码”、“时间”都是一样的话，可以这么写： with t_temp as (select row_number() over (partition by station_name order by param_name asc) id, t.* from t), t_temp1 as (select * from t_temp where id = 1), t_temp2 as (select * from t_temp where id = 2), t_temp3 as