์˜ค๋ฅ˜๋“ค ๐Ÿ˜ค/oracle 5

oracle csv ํ•œ๊ธ€๊นจ์ง

์˜ค๋ผํด์— ์—‘์…€์„ ๋„ฃ์–ด ์ฃผ๊ธฐ๋กœ ํ•˜์˜€๋‹ค...! (dbeaver ์—์„œ ์‚ฌ์šฉ!) ์—‘์…€ ํŒŒ์ผ ๋„ฃ์–ด์ฃผ๊ธฐ๋งŒ ํ•˜๋ฉด ํ•œ๊ธ€์ด ์ด๋ ‡๊ฒŒ ๊นจ์ง€๋Š” ํ˜„์ƒ ๋ฐœ๊ฒฌ.... ใ…œ0ใ…œ ์ด๋ฆฌ์ €๋ฆฌ ์ฐพ์•„๋ณด์•˜๋‹ค. ์šฐ์„  ๋‚˜ํ•œํ…Œ (๋‚ด๊ฐ€ ์ž‘์—…ํ•ด์•ผํ•˜๋Š”) ๋งž๋Š” ๋ถ€๋ถ„์€ ์—‘์…€์˜ ๋ฒ„์ „์— ๋”ฐ๋ฅธ ์ธ์ฝ”๋”ฉ์ด ๋‹ค๋ฅธ ์˜ค๋ฅ˜! ๋ฐ์ดํ„ฐ ๋กœ๋“œํ•˜๊ณ  ์‹ถ์€ ํŒŒ์ผ์„ ์ฐพ์•„๊ฐ€์„œ ๋‹ค๋ฅธ ์ด๋ฆ„์œผ๋กœ ์ €์žฅ ํŒŒ์ผํ˜•์‹csv๋กœ ์ €์žฅ์„ ๋ˆŒ๋Ÿฌ์•ผํ•˜๋Š”๋ฐ, ์ด๊ฑฐ ํ•˜๋‚˜ ๋ฐ–์— ์—†๋‹ค... csv (utf-8 ๋กœ ์ €์žฅ) ์ด ์žˆ์–ด์•ผํ•จ...! ์—‘์…€ ๋ฒ„์ „ 2013 ์ด๋ผ ๋‚ฎ์•„์„œ ์—†๋Š” ๋“ฏ ํ•ด๊ฒฐ๋ฐฉ์•ˆ!! ์ € ์—‘์…€ ํŒŒ์ผ์„ ๋ฉ”๋ชจ์žฅ์œผ๋กœ ๋“œ๋ž˜๊ทธํ•˜์—ฌ ๋ฉ”๋ชจ์žฅ์—์„œ ์—ด์–ด์ค๋‹ˆ๋‹ค. ๋ฉ”๋ชจ์žฅ ํŒŒ์ผ ์—ด๊ณ , ์ด๋ ‡๊ฒŒ ํ•˜์—ฌ ๋‹ค์‹œ ์—‘์…€๋กœ ์ €์žฅ ! ์ธ์ฝ”๋”ฉ์—์„œ UTF-8 ์„ ํƒํ•ด์คŒ! ๊ทธ๋Ÿฌ๋ฉด ๊ธ€์ž๊ฐ€ ๊นจ์ง€์ง€ ์•Š๊ณ  ์ด์˜๊ฒŒ ๋“ค์–ด๊ฐ‘๋‹ˆ๋‹ค!0!0!0! ๐Ÿ™Œ๐Ÿ™Œ๐Ÿ™Œ๐Ÿ™Œ๐Ÿ™Œ

ORA-00979: not a GROUP BY expression

SQL Error [979] [42000]: ORA-00979: not a GROUP BY expression ์ด๋ ‡๊ฒŒ ์˜ค๋ฅ˜ ๋‚ฌ์„ ๊ฒฝ์šฐ? group by ๊ตฌ๋ฌธ์— ๊ทธ๋ฃน ํ•จ์ˆ˜ ์™ธ์— ์กฐํšŒํ•˜๋Š” column ๋ฅผ ๋ชจ๋‘ ํ‘œ์‹œํ•ด์•ผ! ์ฆ‰, select ์ ˆ์˜ ์ปฌ๋Ÿผ๊ณผ group by ์ ˆ์˜ ์ปฌ๋Ÿผ์ด ๊ฐ™์ง€ ์•Š์•„์„œ!

ORA-00920: invalid relational operator

๊ด€๊ณ„ ์—ฐ์‚ฐ์ž๊ฐ€ ๋ถ€์ ํ•ฉํ•˜๋‹ค๋Š” ์˜ค๋ฅ˜, SELECT first_name, last_name, salary FROM EMPLOYEES WHERE salary betweeen 4000 AND 8000; ์ด๋ ‡๊ฒŒ ์ž‘์„ฑํ•˜์˜€๋Š”๋ฐ, between ์„ ์ธ์‹ ๋ชปํ•œ๋“ฏ ํ•˜์—ฌ ์ง€์šฐ๊ณ  ๋‹ค์‹œ ์ž‘์„ฑํ•˜์˜€๋‹ค. between ์ƒ‰๊น” ์ง„ํ•ด์ง€๋ฉฐ, ์ธ์‹ ์ž˜ ๋œ ๋“ฏ ํ•จ. ์ž˜๋Œ์•„๊ฐ.

ORA-12514 ์˜ค๋ฅ˜ ๋ฐœ์ƒ

dbeaver ๋น„๋ฒ„๋ž‘ oracle์˜ hr์œ ์ €๋ž‘ ์—ฐ๊ฒฐํ•˜๋Š” ๋„์ค‘ ๋ฐœ์ƒํ•œ. ์•„๋งˆ๋„, listener๊ฐ€ ์ œ๋Œ€๋กœ ์ž‘๋™ํ•˜์ง€ ์•Š๋Š”๋‹ค๋Š”... ์ด ์นœ๊ตฌ ์ €๋ฒˆ์—๋„ ๋ดค์—ˆ๋Š”๋ฐ,,,, ๊ทธ๋•Œ ํ•ด๊ฒฐ ์–ด๋–ป๊ฒŒ ํ–ˆ์—ˆ๋”๋ผ? ๋‹ต๋‹ตํ•˜๋‹ค ์ฆ๋ง~ โ• ๋ฐฉ๋ฒ• 1 ์„œ๋น„์Šค ์˜ค๋ผํด listener ์žฌ์‹œ๋™ ํ•˜๊ธฐ ๋‹ค์‹œ ์‹œ์ž‘ ํ•˜๋ฉด ์ •์ƒ ์ž‘๋™ ์ด ๋  ์ˆ˜ ๋„ ์žˆ๋‹ค! โ• ๋ฐฉ๋ฒ• 2 lsnrctl์ด ์ •์ƒ ์ž‘๋™์ธ์ง€ ํ™•์ธ cmd> lsnrctl services cmd> lsnrctl status ๋‘˜๋‹ค ์ •์ƒ ์ž‘๋™... โ• ๋ฐฉ๋ฒ• 3 tnsnames.ora listener.ora ํ™•์ธํ•˜๊ธฐ ์‚ฌ์‹ค ์ œ์ผ ์œ ๋ ฅํ•˜๋‹ค... ์—ฌ๊ธฐ oracle์— ๋‹ค๋ฅธ ๊ฒƒ ๋ถ™์—ฌ๋ณด๊ฒ ๋‹ค๊ณ  ์ด๊ฑฐ ์ˆ˜์ •ํ–ˆ๋˜ ๊ธฐ์–ต์ด ๋‚œ๋‹ค ๐Ÿคฆโ€โ™‚๏ธ๐Ÿคฆโ€โ™‚๏ธ ๋‚˜์˜ ๊ฒฝ๋กœ : C:\oraclexe\app\oracle\product\11.2.0..