Hi All,
I need a logic for to convert columns into rows. I have multiple columns they will as one row. I'm giving the sample data below. Is there any can we do this using unpivot or any other analytical function. Please help me out.
SELECT 'FRANCE' ,'USA','UK','FR100' FRAN_CODE,'102020' US_OCDE,'2032' US_CODE FROM DUAL;
COUNTRY CODE
======= ====
FRANCE FR100
USA 102020
UK 2032
Thanks a lot.
Regards,
Ramana.