가로를 세로로

SELECT NAME,
ID,
FIRST_QUARTER,
SECOND_QUARTER,
THIRD_QUARTER,
FOURTH_QUARTER
FROM PINO93.SALETB_SALE




SELECT NAME,
ID,
DECODE(LV, 1, FIRST_QUARTER, 2, SECOND_QUARTER, 3, THIRD_QUARTER, 4, FOURTH_QUARTER) DATA
FROM (
SELECT NAME,
ID,
FIRST_QUARTER,
SECOND_QUARTER,
THIRD_QUARTER,
FOURTH_QUARTER
FROM PINO93.SALETB_SALE ),
(
SELECT LEVEL LV
FROM DUAL CONNECT BY LEVEL <= 4)