SQL 行转列

1. MySQL

   mysql���行使用'\n'

SELECTpic_business_id,GROUP_CONCAT( '\n类型', ':', pic_med_type_name, ',金额', pic_cost ) FROM`sl_patient_item_cost` GROUP BYpic_business_id

2. Oracle

oracle换行使用CHR( 10 )

SELECT    MEDICAL_RECORD_ID,    IN_NUMBER,    NAME,    REPLACE( wmsys.wm_concat ( CHR( 10 ) || FIEID || ':' || ERRO || ';'  ),';,' , ';') as ERROFROM    "MR_IN_ERROR"WHERE FILE_ID = #{fileId}GROUP BY    MEDICAL_RECORD_ID, IN_NUMBER,NAME