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
- Swift
- MSsql
- swift ๋ฉ๋ชจ์ฅ ๋ง๋ค๊ธฐ
- js ์ ์์๋ช
- ์ ์์๋ช ๊ฐ๋ฐ
- mysql
- outofmemoryerror ๋ฐฉ์ง
- xlsx-streamer
- poi ๋์ฉ๋
- ๋ฌ๋ ฅ๊ธฐ๋ฅ๊ฐ๋ฐ
- PostgreSQL
- Xcode
- poi monitorjbl
- xcode swift memo
- jxls ์์
- js๋ฌ๋ ฅ
- ๋์ฉ๋์์ ์ ๋ก๋
- Oracle
- fullcalendar js
- xssreader
- spring annotation
- ios app ๊ฐ๋ฐ
- ์ ์์๋ช ๊ธฐ๋ฅ๊ตฌํ
- swift ๊ณ์ฐ๊ธฐ
- opcpackage
- xcode12.5.1
- xssfworkbook
- jxls
- monitorjbl ์์
- monitorjbl
Archives
- Today
- Total
web developer๐ฉ๐ป๐ป
[Oracle] ORA-01481: ์ซ์ ํ์ ๋ชจ๋ธ์ด ๋ถ์ ํฉํฉ๋๋ค ๋ณธ๋ฌธ
728x90
ORA-01481: ์ซ์ ํ์ ๋ชจ๋ธ์ด ๋ถ์ ํฉํฉ๋๋ค
01481. 00000 - "invalid number format model"
*Cause: The user is attempting to either convert a number to a string
via TO_CHAR or a string to a number via TO_NUMBER and has
supplied an invalid number format model parameter.
*Action: Consult your manual.์์ธ : CHAR ํ์์ด ์๋๊ณ NUMBER ํ์์ผ๋ก ์ธ์๋์ด์
ํด๊ฒฐ : TO_CHAR ํจ์๋ก CHAR ํ์์ผ๋ก ๋ณ๊ฒฝ
TO_CHAR(TO_DATE(re_date, 'yyyymmdd'),'yyyy') AS re_date
'DB' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
| [SQL] where์ 1=0 (false) ์ฌ์ฉ์์ (0) | 2021.07.09 |
|---|---|
| [Oracle] ๋ค์ค LIKE OR / REGEXP_LIKE // IN (2) | 2021.06.29 |
| [Oracle] DECODE ์ CASE ๋น๊ต (0) | 2021.05.27 |
| [Oracle] ORA-01861: ๋ฆฌํฐ๋ด์ด ํ์ ๋ฌธ์์ด๊ณผ ์ผ์นํ์ง ์์ (5) | 2021.05.25 |
| [Oracle] PIVOT ์ฌ์ฉํ๊ธฐ (0) | 2021.05.25 |
'DB' Related Articles
more
