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 | 31 |
Tags
- jxls
- ios app ๊ฐ๋ฐ
- ์ ์์๋ช ๊ฐ๋ฐ
- opcpackage
- outofmemoryerror ๋ฐฉ์ง
- ์ ์์๋ช ๊ธฐ๋ฅ๊ตฌํ
- jxls ์์
- Oracle
- monitorjbl ์์
- xcode swift memo
- Xcode
- js๋ฌ๋ ฅ
- ๋์ฉ๋์์ ์ ๋ก๋
- PostgreSQL
- swift ๊ณ์ฐ๊ธฐ
- fullcalendar js
- spring annotation
- poi ๋์ฉ๋
- swift ๋ฉ๋ชจ์ฅ ๋ง๋ค๊ธฐ
- Swift
- js ์ ์์๋ช
- poi monitorjbl
- ๋ฌ๋ ฅ๊ธฐ๋ฅ๊ฐ๋ฐ
- mysql
- MSsql
- xssreader
- xlsx-streamer
- xcode12.5.1
- monitorjbl
- xssfworkbook
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 |