Oracle 行转列

select id,v1, v2, v3, v4,v5,v6,v7,v8,v9,v10,v11,v12,v13,v14,v15,v16,v17,v18,v19,v20,v21,v22,v23,v24,v25  from gzdb_report_content;

将行专列：

select id,conten,vfg from gzdb_report_content 
	        unpivot(
	           conten for vfg in (v1, v2, v3, v4,v5,v6,v7,v8,v9,v10,v11,v12,v13,v14,v15,v16,v17,v18,v19,v20,v21,v22,v23,v24,v25)
	       ) ;

 

转载于:https://www.cnblogs.com/ckxlovejava/p/7717474.html