oracle中如何用sql实现多条记录合并成一条记录？

行转列。。。。 select * from ( (select tundishno,origin as a1 from 表 where strandid='1') a, (select tundishno,origin as a1 from 表 where strandid='2') b, (select tundishno,origin as a1 from 表 where strandid='3') c, (select tundishno,o