ORA-00979 1
[MyBatis] java.sql.SQLSyntaxErrorException: ORA-00979: GROUP BY ํ‘œํ˜„์‹์ด ์•„๋‹™๋‹ˆ๋‹ค.

[์—๋Ÿฌ ๋กœ๊ทธ] java.sql.SQLSyntaxErrorException: ORA-00979: GROUP BY ํ‘œํ˜„์‹์ด ์•„๋‹™๋‹ˆ๋‹ค. ์ด ์—๋Ÿฌ๋Š” ์ด์ƒํ•˜๊ฒŒ๋„ ์ฟผ๋ฆฌ๋ฅผ ์ง์ ‘ SQLํˆด์—์„œ ๋Œ๋ ค๋ณด๋ฉด ๋ฌธ์ œ์—†์ด ์‹คํ–‰๋˜๋Š”๋ฐ ๋งˆ์ด๋ฐ”ํ‹ฐ์Šค์—์„œ ์‹คํ–‰ํ•˜๊ฒŒ๋˜๋ฉด ์—ฌ๊น€์—†์ด ์ € ์—๋Ÿฌ๋ฅผ ๋ฐœ์ƒ์‹œํ‚จ๋‹ค โœ” Solution ํ•ด๊ฒฐํ•˜๊ธฐ์œ„ํ•ด ๊ฒ€์ƒ‰์„ ํ•ด๋ณด๋ฉด ์ฒซ๋ฒˆ์งธ๋กœ๋Š” ์ •๋ง๋กœ ๋ฌธ๋ฒ•์„ ํ‹€๋ฆฐ ๊ฒฝ์šฐ์ด๋‹ค ํ•˜์ง€๋งŒ ๋‚˜์˜ ๊ฒฝ์šฐ์—๋Š” SQLํˆด์—์„œ๋Š” ์ •์ƒ์‹คํ–‰์ด ๋˜์—ˆ๊ธฐ๋•Œ๋ฌธ์— SQL๋ฌธ๋ฒ•์˜ ๋ฌธ์ œ๋Š” ์•„๋‹ˆ๋‹ค ์กฐ๊ธˆ๋” ๊ฒ€์ƒ‰ํ•ด๋ณธ๊ฒฐ๊ณผ ๋งˆ์ด๋ฐ”ํ‹ฐ์Šค์˜ ๋™์ž‘ ๋ฐฉ์‹์— ๋ฌด์–ธ๊ฐ€ ์žˆ๋‹ค๋Š”๊ฒƒ์„ ์•Œ์•˜๋‹ค ์ž์„ธํ•œ ์ด์œ ๋Š” ์ฐพ์•„๋ด์•ผ ์•Œ๊ฒ ์ง€๋งŒ https://okky.kr/articles/221268 ์ด ๊ธ€์„ ๋ณด๊ณ  ์•Œ๊ฒŒ๋˜์—ˆ๋‹ค ๊ทธ๋ž˜์„œ GROUP BY์— ์ž‘์„ฑ๋˜์–ด์žˆ๋Š” TO_CHARํ•จ์ˆ˜๋ฅผ ์ œ๊ฑฐํ–ˆ๊ณ  ์ •์ƒ๋™์ž‘ํ•˜๋Š”๊ฒƒ์„ ํ™•์ธํ–ˆ๋‹ค
Dev_Log 2022.11.28
1
๋”๋ณด๊ธฐ
728x90
๋ฐ˜์‘ํ˜•

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”