์นดํ
๊ณ ๋ฆฌ ์์
์ค๋ผํด ๋ฐ์ดํฐ ์ด์์ ํ์ผ๋ก Column ์์ Row ๋ก ์ธํผ๋ฒ unpivot
๐ฉท ์ ๐งก
2022. 1. 13. 16:48
728x90
SMALL
A B C D E
11 22 33 44 55
์ผ๋ก๋ ๋ฐ์ดํฐ๋ฅผ
colnm colval
A 11
B 22
C 33
D 44
E 55
์ผ๋ก ๋ณ๊ฒฝ
select colnm, colval
from (
select
11 as A
, 22 as B
, 33 as C
, 44 as D
, 55 as E
from dual
) unpivot (
colval for
colnm in (
A, B, C, D,E
)
)
728x90
LIST