Oracle 11g ์ด์ PIVOTํจ์๋ฅผ ์ฌ์ฉํ ์ ์๊ธฐ์ ํ์ฌ ์ฌ์ฉ์ค์ธ ์ค๋ผํด ๋ฒ์ ์ ์์๋ณด๋ ค๊ณ ํ๋ค. 1. SELECT * FROM v$version; SELECT * FROM v$version; Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production "CORE11.2.0.1.0Production" TNS for 64-bit Windows: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production 2. cmd ์ฐฝ - sqlplus "/as sysdba" sqlplus "/as sys..