728x90
๋ฐ˜์‘ํ˜•

์ „์ฒด ๊ธ€ 1376

[Error][Mybatis] Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for *

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for basic.api.mrOfbs.mrOfbsDetail ### Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for basic.api.mrOfbs.mrOfbs..

Error 2024.07.26

[Error][Oracle] SQL Error [32039] [99999]: ORA-32039: ์ˆœํ™˜ WITH ์ ˆ์—๋Š” ์—ด ๋ณ„์นญ ๋ชฉ๋ก์ด ์žˆ์–ด์•ผ ํ•ฉ๋‹ˆ๋‹ค.

WITH DR (DT) AS ( SELECT TO_CHAR(SYSDATE, 'YYYY') || '-01-01' AS DT FROM DUAL UNION ALL SELECT TO_CHAR(ADD_MONTHS(TO_DATE(DT, 'YYYY-MM-DD'), 1), 'YYYY-MM-DD') FROM DR WHERE DT    " (DT)๋ฅผ ์ถ”๊ฐ€ํ•ด์•ผํ•˜๋Š” ์ด์œ ๋ฅผ ๋ชจ๋ฅด๊ฒ ์–ด์š”. "" ORACLE WITH ์ ˆ ์˜†์— ()๋กœ DT ๋ช…์นญ์„ ์ž…๋ ฅํ•ด์ฃผ์–ด์•ผ ํ•˜๋Š” ์ด์œ ๊ฐ€ ๊ถ๊ธˆํ•ฉ๋‹ˆ๋‹ค."  Oracle์—์„œ ์žฌ๊ท€ ์ ˆ์„ ์‚ฌ์šฉํ•  ๋•Œ WITH, ์žฌ๊ท€ ์ฟผ๋ฆฌ์˜ ๊ตฌ์กฐ๋ฅผ ์ •์˜ํ•˜๊ธฐ ์œ„ํ•ด ์—ด ๋ณ„์นญ์„ ๋ช…์‹œ์ ์œผ๋กœ ์ง€์ •ํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. ์ด ์š”๊ตฌ ์‚ฌํ•ญ์€ ์ฟผ๋ฆฌ์˜ ์žฌ๊ท€ ๋ถ€๋ถ„์ด ์‚ฌ์šฉ ์ค‘์ธ ์—ด์„ ์ ์ ˆํ•˜๊ฒŒ ์ฐธ์กฐํ•  ์ˆ˜ ์žˆ๋„๋ก ๋ณด์žฅํ•ฉ๋‹ˆ๋‹ค.๊ฐ„๋‹จํžˆ..

Error 2024.07.25

[DB][Oracle] FETCH FIRST 1 ROW ONLY ์™€ ROWNUM 1์˜ ์ฐจ์ด

FETCH FIRST 1 ROW ONLY์™€ ROWNUM = 1์€ Oracle SQL์—์„œ ํŠน์ • ๊ฐœ์ˆ˜์˜ ํ–‰์„ ๊ฐ€์ ธ์˜ฌ ๋•Œ ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค. ๊ทธ๋Ÿฌ๋‚˜ ์ด ๋‘ ๊ฐ€์ง€๋Š” ์„œ๋กœ ๋‹ค๋ฅธ ๋ฐฉ์‹์œผ๋กœ ๋™์ž‘ํ•˜๋ฉฐ, ์‚ฌ์šฉ ์‚ฌ๋ก€์— ๋”ฐ๋ผ ์ ํ•ฉํ•œ ์ƒํ™ฉ์ด ๋‹ค๋ฆ…๋‹ˆ๋‹ค. FETCH FIRST 1 ROW ONLY์ด ๊ตฌ๋ฌธ์€ SQL:2008 ํ‘œ์ค€์— ๋„์ž…๋œ ๊ตฌ๋ฌธ์œผ๋กœ, ํŠน์ • ์ˆ˜์˜ ํ–‰์„ ๊ฐ€์ ธ์˜ค๋Š” ์ž‘์—…์„ ์ˆ˜ํ–‰ํ•ฉ๋‹ˆ๋‹ค. ORDER BY ์ ˆ๊ณผ ํ•จ๊ป˜ ์‚ฌ์šฉ๋  ๋•Œ ํŠนํžˆ ์œ ์šฉํ•˜๋ฉฐ, ๊ทธ ์˜๋ฏธ๊ฐ€ ๋ช…ํ™•ํ•ฉ๋‹ˆ๋‹ค. ์˜ˆ๋ฅผ ๋“ค์–ด, ๊ฐ€์žฅ ๋†’์€ ์ ์ˆ˜๋ฅผ ๊ฐ€์ง„ ํ•™์ƒ์˜ ์ •๋ณด๋ฅผ ๊ฐ€์ ธ์˜ฌ ๋•Œ ORDER BY score DESC์™€ ํ•จ๊ป˜ ์‚ฌ์šฉํ•˜๋ฉด ๋ฉ๋‹ˆ๋‹ค.SELECT *FROM studentsORDER BY score DESCFETCH FIRST 1 ROW ONLY; ์ด ๊ตฌ๋ฌธ์€ ORDER BY ์ ˆ์ด ์žˆ๋Š” ์ƒํ™ฉ..

DB 2024.07.24

[DB][Oracle] FETCH FIRST 1 ROW ONLY

FETCH FIRST 1 ROW ONLYOracle SQL์—์„œ ๊ฐ€์žฅ ์ฒซ ๋ฒˆ์งธ ํ–‰๋งŒ ๊ฐ€์ ธ์˜ค๋Š” ๊ตฌ๋ฌธ์ž…๋‹ˆ๋‹ค. MySQL์˜ LIMIT 1๊ณผ ์œ ์‚ฌํ•ฉ๋‹ˆ๋‹ค.https://jjoyling.tistory.com/38 [ORACLE] ํ–‰ ์ œํ•œํ–‰ ์ œํ•œ ํŠน์ • ์กฐ๊ฑด์— ๋”ฐ๋ผ ํ–‰ ๊ฐœ์ˆ˜๋ฅผ ์ œํ•œํ•˜๊ธฐ ์œ„ํ•ด ์‚ฌ์šฉํ•˜๋Š” SQL OFFSET ๊ฑด์ˆ˜ { ROW | ROWS } FETCH { FIRST | NEXT } { ๊ฑด์ˆ˜ | ์ˆซ์ž PERCENT } {ROW | ROWS} { ONLY | WITH TIES } ORDER BY SQL ์ˆ˜ํ–‰ ๊ฒฐ๊ณผ์˜ ์ •๋ ฌ ๊ธฐ์ค€ OFFSET ํ–‰jjoyling.tistory.com

DB 2024.07.23

[Error][DB] SQL Error [904] [42000]: ORA-00904: "์˜คํ›„": ๋ถ€์ ํ•ฉํ•œ ์‹๋ณ„์ž

Oracle์—์„œ ๋ฌธ์ž์—ด ๋ฆฌํ„ฐ๋Ÿด์„ ์‚ฌ์šฉํ•  ๋•Œ์—๋Š” ํ•ญ์ƒ ์ž‘์€๋”ฐ์˜ดํ‘œ(')๋ฅผ ์‚ฌ์šฉํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค."์˜ค์ „"๊ณผ "์˜คํ›„"๋Š” ๋ฌธ์ž์—ด ๋ฆฌํ„ฐ๋Ÿด๋กœ ์ธ์‹๋˜๊ธฐ ์œ„ํ•ด ์ž‘์€๋”ฐ์˜ดํ‘œ๋กœ ๊ฐ์‹ธ์ ธ์•ผ ํ•ฉ๋‹ˆ๋‹ค.

Error 2024.07.22

[DB][Oracle] T0_CHAR ๋‚ ์งœํ˜•์‹

https://velog.io/@newv/Oracle-%ED%95%A8%EC%88%98-TOCHAR%EC%99%80-TODATE-%EA%B0%84%EB%8B%A8-%EB%B9%84%EA%B5%90-%EB%B0%8F-%EC%82%AC%EC%9A%A9%EC%98%88%EC%A0%9CTO_CHAR(๋‚ ์งœํƒ€์ž…๊ฐ’, '๋‚ ์งœํฌ๋งท') : ๋‚ ์งœํƒ€์ž…์˜ ๋ฐ์ดํ„ฐ๋ฅผ '๋‚ ์งœํฌ๋งท'์— ๋”ฐ๋ผ ๋ฌธ์ž์—ด๋กœ ๋ณ€ํ™˜ >" data-og-host="velog.io" data-og-source-url="https://velog.io/@newv/Oracle-%ED%95%A8%EC%88%98-TOCHAR%EC%99%80-TODATE-%EA%B0%84%EB%8B%A8-%EB%B9%84%EA%B5%90-%EB%B0%8F-%EC%82%AC%EC%9A%A9%E..

DB 2024.07.21

[CSS] visibility : ์š”์†Œ๋ฅผ ์ˆจ๊ธฐ๊ณ  ๊ณต๊ฐ„์€ ๊ทธ๋Œ€๋กœ ์œ ์ง€ํ•˜๊ธฐ

style="display:none;"์œผ๋กœ ์„ค์ •ํ–ˆ๋Š”๋ฐ ํ•ด๋‹น ์˜์—ญ์˜ ๋†’์ด๋งŒํผ ์ž๋ฆฌ์ฐจ์ง€๋Š” ํ•˜๊ฒŒ ํ•ด์ฃผ๊ณ  ์‹ถ์œผ๋ฉด ์–ด๋–ป๊ฒŒ ํ•ด์•ผ๋ ๊นŒ? Visibility๋ฅผ ํ™œ์šฉํ•˜๋Š” ๋ฐฉ๋ฒ•:๋‚ด์šฉvisibility:hidden; ์†์„ฑ์€ ์š”์†Œ๋ฅผ ๋ณด์ด์ง€ ์•Š๊ฒŒ ํ•˜์ง€๋งŒ, ๊ณต๊ฐ„์€ ๊ทธ๋Œ€๋กœ ์œ ์ง€ํ•ฉ๋‹ˆ๋‹ค. style="visibility:hidden;" ์„ ํ•ด์ œํ•˜๋Š” jquery ์ฝ”๋“œ $('#myElement').css('visibility', 'visible'); ์ด ์˜์—ญ์€ ์ฒ˜์Œ์— ๋ณด์ด์ง€ ์•Š์Šต๋‹ˆ๋‹ค. Show Element

Front/CSS 2024.07.20

[Error][DB][Oracle] ORA-00932: ์ผ๊ด€์„ฑ ์—†๋Š” ๋ฐ์ดํ„ฐ ์œ ํ˜•: CHAR์ด(๊ฐ€) ํ•„์š”ํ•˜์ง€๋งŒ NUMBER์ž„

์˜ค๋ฅ˜ ORA-00932: ์ผ๊ด€์„ฑ ์—†๋Š” ๋ฐ์ดํ„ฐ ์œ ํ˜•: CHAR์ด(๊ฐ€) ํ•„์š”ํ•˜์ง€๋งŒ NUMBER์ž„์€ SQL ์ฟผ๋ฆฌ์—์„œ ๋ฐ์ดํ„ฐ ํƒ€์ž…์ด ์ผ์น˜ํ•˜์ง€ ์•Š์„ ๋•Œ ๋ฐœ์ƒํ•ฉ๋‹ˆ๋‹ค. ์ด ๊ฒฝ์šฐ, COALESCE ํ•จ์ˆ˜์™€ ํ•จ๊ป˜ ์‚ฌ์šฉ๋œ ๋ฐ์ดํ„ฐ ํƒ€์ž…์— ์ฃผ์˜ํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. ํŠนํžˆ, VARCHAR ํƒ€์ž…๊ณผ NUMBER ํƒ€์ž…์ด ํ˜ผํ•ฉ๋˜์–ด ์‚ฌ์šฉ๋  ๋•Œ ์ด ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ๋ฌธ์ œ๋๋˜ ๋ถ€๋ถ„ , COALESCE(NULL,0) ์ˆ˜์ •, COALESCE(TO_NUMBER(NULL),0) TO_NUMBER ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ NULL ๊ฐ’์„ ์ˆซ์ž๋กœ ๋ณ€ํ™˜ํ–ˆ์Šต๋‹ˆ๋‹ค. ์ˆซ์ž๋ฅผ ์ž…๋ ฅํ•ด์•ผํ•˜๋Š” ์ปฌ๋Ÿผ์— NULL ๊ฐ’์ด ๋“ค์–ด์™”์„ ๋•Œ ์ˆซ์ž๋กœ ๋ณ€ํ™˜ํ•ด์ฃผ์–ด์•ผ ์ œ๋Œ€๋กœ ๊ฐ’์ด ์ž…๋ ฅ๋˜์—ˆ๋‹ค.MySQL์—์„œ๋Š” ์ƒ๊ด€์ด ์—†์—ˆ๋Š”๋ฐ, ๋ฐ์ดํ„ฐ ํƒ€์ž…์— ๋”์šฑ ๋ฏผ๊ฐํ•˜๋„ค..

Error 2024.07.19

[Error][DB][Oracle] ์ธ์ˆ˜์˜ ๊ฐœ์ˆ˜๊ฐ€ ๋ถ€์ ํ•ฉํ•ฉ๋‹ˆ๋‹ค

์ž‘์„ฑํ•˜์‹  SQL ์ฟผ๋ฆฌ๋Š” ํŠน์ • ํ˜•์‹์˜ ์ฝ”๋“œ๋ฅผ ์ƒ์„ฑํ•˜๊ธฐ ์œ„ํ•œ ์ฟผ๋ฆฌ์ž…๋‹ˆ๋‹ค. ์ด ์ฟผ๋ฆฌ์—์„œ "์ธ์ˆ˜์˜ ๊ฐœ์ˆ˜๊ฐ€ ๋ถ€์ ํ•ฉํ•ฉ๋‹ˆ๋‹ค"๋ผ๋Š” ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒํ•˜๋Š” ์ด์œ ๋Š” CONCAT ํ•จ์ˆ˜์˜ ์ธ์ˆ˜ ๊ฐœ์ˆ˜ ๋ฌธ์ œ์ผ ๊ฐ€๋Šฅ์„ฑ์ด ํฝ๋‹ˆ๋‹ค. ์˜ค๋ผํด์˜ CONCAT ํ•จ์ˆ˜๋Š” ๋‘ ๊ฐœ์˜ ์ธ์ˆ˜๋งŒ ๋ฐ›์„ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ๋”ฐ๋ผ์„œ ์—ฌ๋Ÿฌ ๋ฌธ์ž์—ด์„ ์—ฐ๊ฒฐํ•˜๋ ค๋ฉด || ์—ฐ์‚ฐ์ž๋ฅผ ์‚ฌ์šฉํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. ๊ธฐ์กด์— MySQL์ฟผ๋ฆฌ๋ฅผ Oracle ์ฟผ๋ฆฌ๋กœ ๋ฐ”๊ฟ”์•ผ ํ•˜๋Š”๋ฐ, Oracle ์€ concat ํ•จ์ˆ˜๋กœ ์ธ์ž๋ฅผ ๋‘๊ฐœ๋งŒ ๋ฐ›์•„์„œ  ์ฟผ๋ฆฌ์—์„œ ์˜ค๋ฅ˜๊ฐ€ ๋‚ฌ๋‹ค.

Error 2024.07.18

[DB][Oracle] PL/SQL ๋ธ”๋ก์„ ์‚ฌ์šฉํ•˜์—ฌ ํ•œ๋ฒˆ์— insert ํ•˜๊ธฐ

SET @TNT = (SELECT TENANT_CD FROM SYS_COMPANY LIMIT 1);MysQL ์—์„  ๋ณ€์ˆ˜๋ฅผ ์„ธํŒ…ํ•ด์„œ ํ•œ๋ฒˆ์— Insert ๋ฌธ์„ ์“ธ ๋•Œ ์‚ฌ์šฉํ–ˆ๋Š”๋ฐ,Oracle์—์„œ ๋ณ€์ˆ˜๋ฅผ ์‚ฌ์šฉํ•  ์ˆ˜ ์—†๊ธฐ ๋•Œ๋ฌธ์— ์ง์ ‘ ๋ณ€์ˆ˜๋ฅผ ์‚ฌ์šฉํ•˜๋Š” ๋ฐฉ์‹(@TNT)์„ ์‚ฌ์šฉํ•  ์ˆ˜ ์—†์Šต๋‹ˆ๋‹ค.๋Œ€์‹ , ๋ณ€์ˆ˜๋ฅผ ์‚ฌ์šฉํ•  ํ•„์š”๊ฐ€ ์žˆ๋Š” ๊ฒฝ์šฐ PL/SQL ๋ธ”๋ก์„ ์‚ฌ์šฉํ•˜๊ฑฐ๋‚˜ ๋‹ค๋ฅธ ๋ฐฉ๋ฒ•์œผ๋กœ ๊ฐ’์„ ์ „๋‹ฌํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค.DECLARE v_tenant VARCHAR2(20) := 'TENANT1';BEGIN INSERT INTO SYS_CODE_CLS SELECT v_tenant, 'col1', 'col2', 1, 'col3', 1, NULL, NULL, 0, 1, 'col4', CURRENT_TIMESTAMP, 'col5', ..

DB 2024.07.17
728x90
๋ฐ˜์‘ํ˜•