楼主试试unpivot函数。 CREATE TABLE wsc (v001 VARCHAR2(5),v016 VARCHAR2(5),seq VARCHAR2(5)); INSERT INTO wsc VALUES ('1','2','xy'); COMMIT; SELECT * FROM wsc;SELECT unpivot1 FROM (SELECT v001,v016,seq FROM wsc ) a UNPIVOT (unpivot1 FOR column_type IN (v001,v016,seq)) UNPIVOT;
行:
1 2 XY
2 3 XY1
列:
1 2
2 3
XY XY1
行:
1 2 XY
2 3 XY1
列:
1 2
2 3
XY XY1这个做起来就略困难了,估计只能借助存储过程或者函数来实现了
CREATE TABLE wsc (v001 VARCHAR2(5),v016 VARCHAR2(5),seq VARCHAR2(5));
INSERT INTO wsc VALUES ('1','2','xy');
COMMIT;
SELECT * FROM wsc;SELECT unpivot1 FROM (SELECT v001,v016,seq FROM wsc ) a
UNPIVOT (unpivot1 FOR column_type IN (v001,v016,seq)) UNPIVOT;