Thank you, the following line is used to turn column grammar into ORACLE how to write?


Select * INTO # DHPJPM from # MDCPM pivot (Max (PM) FOR mdccode (MDCA, MDCB MDCZ)) in A
The select yydm,
Case the when ISNULL (MDCA, ' ')='THEN @ num else MDCA end MDCA,
Case the when ISNULL (MDCB, ' ')='THEN @ num else MDCB end MDCB,
Case the when ISNULL (MDCZ, ' ')='THEN @ num else MDCZ end MDCZ
INTO # PM
The from # DHPJPM