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;