SQL Oracle将列转换为对列\名称/值

UNPIVOT

SQL Fiddle

CREATE TABLE table_name (dog, cat, snake) AS
SELECT 5, 7, 7 FROM DUAL UNION ALL
SELECT 9, 8, 5 FROM DUAL UNION ALL
SELECT 1, 3, 7 FROM DUAL;

SELECT *
FROM   table_name
UNPIVOT(
  value FOR column_name IN ( dog, cat, snake )
)

Results

| COLUMN_NAME | VALUE |
|-------------|-------|
|         DOG |     5 |
|         CAT |     7 |
|       SNAKE |     7 |
|         DOG |     9 |
|         CAT |     8 |
|       SNAKE |     5 |
|         DOG |     1 |
|         CAT |     3 |
|       SNAKE |     7 |

union all

select 'dog' as col, dog
from table t
union all
select 'cat', cat
from table t
union all
select 'snake', snake
from table t;