TransposeStringcolomnvaluestoRowOracle我的初始表是这样的。12345678910111213141516171819202122232425CREATETABLEpivot_string(col1NUMBER,col2NUMBER,col3VARCHAR2(6), col3_idNUMBER,col3_descVARCHAR2(10)); INSERTINTOpivot_stringSELECT123,9875,'RO',40,'Roma'FROMdual; INSERTINTOpivot_stringSELECT123,9875,'IT',40,'ite
TransposeStringcolomnvaluestoRowOracle我的初始表是这样的。12345678910111213141516171819202122232425CREATETABLEpivot_string(col1NUMBER,col2NUMBER,col3VARCHAR2(6), col3_idNUMBER,col3_descVARCHAR2(10)); INSERTINTOpivot_stringSELECT123,9875,'RO',40,'Roma'FROMdual; INSERTINTOpivot_stringSELECT123,9875,'IT',40,'ite