Need help with the SQL, please.
Input table:
| ROW_NAME | COL_NAME | VALUE |
| A | COL1 | VAL1 |
| A | COL2 | VAL2 |
| A | COL3 | VAL3 |
| B | COL1 | VAL4 |
| B | COL2 | VAL5 |
| B | COL3 | VAL6 |
| C | COL1 | VAL7 |
| C | COL2 | VLA8 |
| C | COL3 | VAL9 |
Desired output:
| XTRA | COL1 | COL2 | COL3 |
| A | VAL1 | VAL2 | VAL3 |
| B | VAL4 | VAL5 | VAL6 |
| C | VAL7 | VAL8 | VAL9 |
SQL to create test table:
SELECT 'A' ROW_NAME, 'COL1' COL_NAME, 'VAL1' VALUE FROM DUAL UNION ALL
SELECT 'A', 'COL2', 'VAL2' FROM DUAL UNION ALL
SELECT 'A', 'COL3', 'VAL3' FROM DUAL UNION ALL
SELECT 'B', 'COL1', 'VAL4' FROM DUAL UNION ALL
SELECT 'B', 'COL2', 'VAL5' FROM DUAL UNION ALL
SELECT 'B', 'COL3', 'VAL6' FROM DUAL UNION ALL
SELECT 'C', 'COL1', 'VAL7' FROM DUAL UNION ALL
SELECT 'C', 'COL2', 'VAL8' FROM DUAL UNION ALL
SELECT 'C', 'COL3', 'VAL9' FROM DUAL