enrique_aeo
asked on
PLSQL - rotate information (PIVOT)
Hi experts:
The information has been save horizontally
codigoMaterialReal Enero Febrero Marzo Abril Mayo Junio
592025000040252 11.6 11.7 12.7 13.7 14.7 15.7
600017000030044 12.78 12.78 12.78 12.8 12.78 12.78
I need to rotate,like this
592025000040252 11.6
592025000040252 11.7
592025000040252 12.7
592025000040252 13.7
592025000040252 14.7
592025000040252 15.7
The information has been save horizontally
codigoMaterialReal Enero Febrero Marzo Abril Mayo Junio
592025000040252 11.6 11.7 12.7 13.7 14.7 15.7
600017000030044 12.78 12.78 12.78 12.8 12.78 12.78
I need to rotate,like this
592025000040252 11.6
592025000040252 11.7
592025000040252 12.7
592025000040252 13.7
592025000040252 14.7
592025000040252 15.7
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i have a sequence
592025000040252 12.7
how will you know which month that represents?