oracle数据库实现横向转纵向输出

代码：

SELECT
	t.CONTRACTNO,
	t.CTIME,
CASE
		
		WHEN to_char( RECORD_TYPE ) IN ( '7', '13' ) THEN
		to_char( fixprice ) ELSE '0' 
	END hxj,
CASE
	
	WHEN to_char( RECORD_TYPE ) = '8' THEN
	to_char( fixprice ) ELSE '0' 
	END hxfj,
CASE
	
	WHEN to_char( RECORD_TYPE ) IN ( '9', '10', '11', '12' ) THEN
	to_char( fixprice ) ELSE '0' 
	END jx,
CASE
	
	WHEN to_char( RECORD_TYPE ) IN ( '1', '2', '3', '4', '5', '6' ) THEN
	to_char( fixprice ) ELSE '0' 
	END xn,
CASE
	
	WHEN to_char( RECORD_TYPE ) IN ( '111' ) THEN
	to_char( fixprice ) ELSE '0' 
	END jj 
FROM
	(
	SELECT
		dlrs.CONTRACTNO,
		dlsp.BTYPE,
		dlms.stype,
		dlms.RECORD_TYPE,
		dlorf.report_type,
		to_char( dlrs.create_time, 'yyyy-mm' ) AS ctime -- ,nvl(dltp.FIXED_PRICE,'0')
		,
		sum( nvl( dltp.FIXED_PRICE, '0' ) ) AS fixprice 
	FROM
		DE_LH_REQUESTUO_SINGLE dlrs
		LEFT JOIN DE_LH_SAMPLESINGLE_PARAM dlsp ON dlsp.REQUESTTUOSIGNLE_ID = dlrs.id
		LEFT JOIN DE_LH_MACHININGTYPE_SUB dlms ON dlms.id = dlsp.SUBTYPE_ID
		LEFT JOIN DE_LH_ORI_RECORD_FORMAT dlorf ON dlorf.id = dlms.RECORD_TYPE
		LEFT JOIN DE_LH_TEST_PRICE dltp ON dltp.TESTITEM_ID = dlsp.TESTITEM_ID 
	WHERE
		TO_CHAR( dlrs.create_time, 'yyyy-MM' ) = '2020-09' 
	GROUP BY
		dlrs.CONTRACTNO,
		dlsp.BTYPE,
		dlms.stype,
		dlms.RECORD_TYPE,
		dlorf.report_type,
	to_char( dlrs.create_time, 'yyyy-mm' ) 
	) t

效果：

大佬勿喷，欢迎提意见建议评论！！！！