Notice
Recent Posts
Recent Comments
Link
์ผ | ์ | ํ | ์ | ๋ชฉ | ๊ธ | ํ |
---|---|---|---|---|---|---|
1 | ||||||
2 | 3 | 4 | 5 | 6 | 7 | 8 |
9 | 10 | 11 | 12 | 13 | 14 | 15 |
16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 | 29 |
30 |
Tags
- swift ๋ฉ๋ชจ์ฅ ๋ง๋ค๊ธฐ
- Oracle
- ๋์ฉ๋์์ ์ ๋ก๋
- poi ๋์ฉ๋
- jxls ์์
- ios app ๊ฐ๋ฐ
- monitorjbl ์์
- js ์ ์์๋ช
- ์ ์์๋ช ๊ธฐ๋ฅ๊ตฌํ
- mysql
- Swift
- fullcalendar js
- MSsql
- jxls
- swift ๊ณ์ฐ๊ธฐ
- xcode swift memo
- outofmemoryerror ๋ฐฉ์ง
- opcpackage
- spring annotation
- xssreader
- PostgreSQL
- xlsx-streamer
- ๋ฌ๋ ฅ๊ธฐ๋ฅ๊ฐ๋ฐ
- poi monitorjbl
- js๋ฌ๋ ฅ
- ์ ์์๋ช ๊ฐ๋ฐ
- Xcode
- monitorjbl
- xssfworkbook
- xcode12.5.1
Archives
- Today
- Total
web developer๐ฉ๐ป๐ป
[Oracle] ์ค๋ผํด ๋ฒ์ ๋ฐ ์๋์ ์ ๋ณด ํ์ธ ๋ณธ๋ฌธ
728x90
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
"CORE 11.2.0.1.0 Production"
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 sysdba"
sqlplus / as sysdba
'DB' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
[Oracle] PIVOT ์ฌ์ฉํ๊ธฐ (0) | 2021.05.25 |
---|---|
[Oracle] cmd sqlplus ์ ์ ์๋ฌ (1) | 2021.05.21 |
[Oracle] SQLDeveloper ๊ธ์ ํฌ๊ธฐ ๋ณ๊ฒฝ (0) | 2021.05.18 |
DB ๊ธฐ๋ณธ ํฌํธ ์ ๋ฆฌ (0) | 2021.04.12 |
[ERwin] ํ ์ด๋ธ ๊ตฌ์ฑ ๋ฐ ์์ฑ ์ฟผ๋ฆฌ ์ถ์ถํ๊ธฐ (2) | 2021.02.16 |