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