시처럼 음악처럼

/* Pivot */WITH wdata AS( SELECT '1001' user_id, 'USE' org, 'Boss' position, 'EN' lang, 100 qty, 25000 amt FROM dual UNION ALL SELECT '1001' user_id, 'USD' org, 'Bossa' position, 'FI' lang, 200 qty, 30000 amt FROM dual UNION ALL SELECT '1002' user_id, 'GWR' org, 'Dim' position, 'SV' lang, 300 qty, 35000 amt FROM dual UNION ALL SELECT '1003' user_id, 'GGA' org, 'DCS' position, 'FI' lang, 400 qty,..

Oracle 11g: Unpivot multiple columns and include column name Unpivot table with multiple columns and dynamic column names