๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
๋ฐ˜์‘ํ˜•

๋ถ„๋ฅ˜ ์ „์ฒด๋ณด๊ธฐ282

[CSS] ์ด๋ฏธ์ง€์— ์ ์šฉํ•œ ๋งˆ์šฐ์Šค hover ํšจ๊ณผ๋“ค (์˜ˆ์‹œํฌํ•จ) โœจCSS Image Hover Effects No Effect 1. Zoom In #1 Hover /* Zoom In #1 */ .hover01 figure img { -webkit-transform: scale(1); transform: scale(1); -webkit-transition: .5s ease-in-out; transition: .5s ease-in-out; } .hover01 figure:hover img { -webkit-transform: scale(1.3); transform: scale(1.3); } 2. Zoom Out #1 Hover /* Zoom Out #1 */ .hover02 figure img { -webkit-transition: .5s ease-in-out; tran.. 2022. 4. 17.
[LeetCode] ๋ฆฟ์ฝ”๋“œ ์‹œ์ž‘ํ•˜๊ธฐ, Github์— ์ž๋™ ์ปค๋ฐ‹(LeetHub) ๋ฐฉ๋ฒ• https://leetcode.com/ LeetCode - The World's Leading Online Programming Learning Platform Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com LeetCode๋Š” ์ „์„ธ๊ณ„์ ์œผ๋กœ ์œ ๋ช…ํ•œ Online Judge Platform ์ž…๋‹ˆ๋‹ค. ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์—์„œ๋„ ์ด๊ณณ ๋ฌธ์ œ๋ฅผ ๋ณ€ํ˜•ํ•ด์„œ ์ถœ์ œ๋˜๋Š” ๋ฌธ์ œ๊ฐ€ ๋งŽ์•˜์Šต๋‹ˆ๋‹ค. ๊ตฌ๊ธ€/๊นƒํ—ˆ๋ธŒ/ํŽ˜์ด์Šค๋ถ ๊ณ„์ •์œผ๋กœ ๊ฐ„ํŽธํ•˜๊ฒŒ ๊ฐ€์ž…ํ›„ ์‚ฌ์šฉ ํ•˜์‹ค์ˆ˜์žˆ์Šต๋‹ˆ๋‹ค. โœจLeetHub : Github ์— ์ž๋™์œผ๋กœ Comm.. 2022. 4. 16.
[Spring] IoC, DL, DI ๋ž€ ๋ฌด์—‡์ธ๊ฐ€์š”? IOC (Inversion of Control), DL(Dependency Lookup), DI (Dependency Injection) โœจ IoC (Inversion of Control) ๋ž€? "์ œ์–ด์˜ ์—ญ์ „" ์ด๋ผ๋Š” ์˜๋ฏธ๋กœ, ๊ฐ์ฒด๋‚˜ ๋ฉ”์„œ๋“œ์˜ ํ˜ธ์ถœ์„ ๊ฐœ๋ฐœ์ž๊ฐ€ ๊ฒฐ์ •ํ•˜๋Š” ๊ฒƒ์ด ์•„๋‹Œ, ๊ฐ์ฒด์˜ ์ƒ์„ฑ์—์„œ๋ถ€ํ„ฐ ์ƒ๋ช…์ฃผ๊ธฐ์˜ ๊ด€๋ฆฌ๊นŒ์ง€ ๋ชจ๋“  ๊ฐ์ฒด์— ๋Œ€ํ•œ ์ œ์–ด๊ถŒ์ด ๋ฐ”๋€Œ์—ˆ๋‹ค๋Š” ๊ฒƒ์„ ์˜๋ฏธํ•œ๋‹ค. โœจ IoC์˜ ์žฅ์  ๊ฐ์ฒด์˜ ์˜์กด์„ฑ์„ ์—ญ์ „์‹œ์ผœ ๊ฐ์ฒด ๊ฐ„์˜ ๊ฒฐํ•ฉ๋„๋ฅผ ์ค„์ด๊ณ  ์œ ์—ฐํ•œ ์ฝ”๋“œ๋ฅผ ์ž‘์„ฑ ํ•  ์ˆ˜ ์žˆ๊ฒŒ ํ•˜์—ฌ ๊ฐ€๋…์„ฑ ๋ฐ ์ฝ”๋“œ ์ค‘๋ณต, ์œ ์ง€ ๋ณด์ˆ˜๋ฅผ ํŽธํ•˜๊ฒŒ ํ•  ์ˆ˜ ์žˆ๊ฒŒ ํ•œ๋‹ค. โœจ IoC์˜ ๋ถ„๋ฅ˜ ( DL / DI ) 1. DL (Dependency Lookup) "์˜์กด์„ฑ ๊ฒ€์ƒ‰" ์ด๋ผ๋Š” ์˜๋ฏธ๋กœ, ์ด๋Š” Bean์— ์ ‘๊ทผํ•˜๊ธฐ ์œ„ํ•ด ์ปจํ…Œ์ด๋„ˆ๊ฐ€ ์ œ๊ณตํ•˜๋Š” .. 2022. 4. 15.
[Oracle] IN, NOT IN ํŠน์ • ๋ฐ์ดํ„ฐ ํฌํ•จ/์ œ์™ธ ํ•˜๊ธฐ ์•ˆ๋…•ํ•˜์„ธ์š” yunamom ์ž…๋‹ˆ๋‹ค. :D ํŠน์ • ๋ฐ์ดํ„ฐ ๊ฐ’์„ ํฌํ•จํ•˜๋Š” ํ˜น์€ ์ œ์™ธํ•œ ๋ฐ์ดํ„ฐ๋ฅผ ์ถ”์ถœํ•˜๊ณ  ์‹ถ์„ ๋•Œ ์‚ฌ์šฉํ•˜๋Š” IN, NOT IN ๋ฌธ ์‚ฌ์šฉ๋ฒ•์— ๋Œ€ํ•˜์—ฌ ํฌ์ŠคํŒ…ํ•˜๊ฒ ์Šต๋‹ˆ๋‹ค.๐Ÿ˜Š โœจIN ๋ฌธ ์‚ฌ์šฉ๋ฒ• SELECT * FROM TABLE WHERE [์ปฌ๋Ÿผ๋ช…] IN ('A','B'); -- ์—ฌ๋Ÿฌ ๋ฐ์ดํ„ฐ ์ œ์™ธ ๊ฐ€๋Šฅ -- IN ๋ฌธ์„ ํ’€์ดํ•œ ์ฟผ๋ฆฌ๋ฌธ SELECT * FROM TABLE WHERE [์ปฌ๋Ÿผ๋ช…] = 'A' OR [์ปฌ๋Ÿผ๋ช…] = 'B' โœจNOT IN ๋ฌธ ์‚ฌ์šฉ๋ฒ• SELECT * FROM TABLE WHERE [์ปฌ๋Ÿผ๋ช…] NOT IN ('A','B'); -- ์—ฌ๋Ÿฌ ๋ฐ์ดํ„ฐ ์ œ์™ธ ๊ฐ€๋Šฅ -- NOT IN ๋ฌธ์„ ํ’€์ดํ•œ ์ฟผ๋ฆฌ๋ฌธ SELECT * FROM TABLE WHERE [์ปฌ๋Ÿผ๋ช…] 'A' AND [์ปฌ๋Ÿผ๋ช…] 'B' โœจSUBQUER.. 2022. 4. 15.
[SQL ์ „๋ฌธ๊ฐ€] ๊ณผ๋ชฉII. ์ œ2์žฅ SQL ํ™œ์šฉ - ์—ฐ์Šต๋ฌธ์ œ ๐Ÿ“–๊ณผ๋ชฉII. ์ œ2์žฅ SQL ํ™œ์šฉ - ์—ฐ์Šต๋ฌธ์ œ (์ด 10๋ฌธ์ œ) ๋ฌธ์ œ 1. ์ผ๋ฐ˜์ ์œผ๋กœ FROM ์ ˆ์— ์ •์˜๋œ ํ›„ ๋จผ์ € ์ˆ˜ํ–‰๋ผ, SQL ๋ฌธ์žฅ ๋‚ด์—์„œ ์ ˆ์ฐจ์„ฑ์„ ์ฃผ๋Š” ํšจ๊ณผ๋ฅผ ๋ณผ ์ˆ˜ ์žˆ๋Š” ๊ฒƒ์€ ์–ด๋–ค ์œ ํ˜•์˜ ์„œ๋ธŒ ์ฟผ๋ฆฌ ๋ฌธ์žฅ์ธ๊ฐ€? ์ •๋‹ตํ™•์ธ๐ŸŒผ 1) SCALAR SUBQUERY 2) NESTED SUBQUERY 3) CORRELATED SUBQUERY 4) INLINE VIEW ๋ฌธ์ œ 2. ๋‹ค์Œ ์„œ๋ธŒ ์ฟผ๋ฆฌ์— ๋Œ€ํ•œ ์„ค๋ช… ์ค‘ ํ‹€๋ฆฐ ๊ฒƒ์„ ๊ณ ๋ฅด์‹œ์˜ค. ์ •๋‹ตํ™•์ธ๐ŸŒผ 1) ๋‹ค์ค‘ ํ–‰ ์—ฐ์‚ฐ์ž๋Š” IN, ANY, ALL์ด ์žˆ์œผ๋ฉฐ, ์„œ๋ธŒ ์ฟผ๋ฆฌ์˜ ๊ฒฐ๊ณผ๋กœ ํ•˜๋‚˜ ์ด์ƒ์˜ ๋ฐ์ดํ„ฐ๊ฐ€ RETURN๋˜๋Š” ์„œ๋ธŒ ์ฟผ๋ฆฌ๋‹ค. 2) Top N ์„œ๋ธŒ ์ฟผ๋ฆฌ๋Š” INLINE VIEW์˜ ์ •๋ ฌ๋œ ๋ฐ์ดํ„ฐ๋ฅผ ROWNUM์„ ์ด์šฉํ•ด ๊ฒฐ๊ณผ ํ–‰์ˆ˜๋ฅผ ์ œํ•œํ•˜๊ฑฐ๋‚˜,TOP(N) ์กฐ๊ฑด์„ ์‚ฌ์šฉํ•˜๋Š” ์„œ๋ธŒ .. 2022. 4. 15.
[SQL ์ „๋ฌธ๊ฐ€] ๊ณผ๋ชฉII. ์ œ2์žฅ SQL ํ™œ์šฉ ๐Ÿ“–์ œ2์žฅ SQL ํ™œ์šฉ ์ œ1์ ˆ ์„œ๋ธŒ ์ฟผ๋ฆฌ ์ œ2์ ˆ ์ง‘ํ•ฉ ์—ฐ์‚ฐ์ž ์ œ3์ ˆ ๊ทธ๋ฃน ํ•จ์ˆ˜ ์ œ4์ ˆ ์œˆ๋„์šฐ ํ•จ์ˆ˜ ์ œ5์ ˆ Top N ์ฟผ๋ฆฌ ์ œ6์ ˆ ๊ณ„์ธตํ˜• ์งˆ์˜์™€ ์…€ํ”„ ์กฐ์ธ ์ œ7์ ˆ PIVOT ์ ˆ๊ณผ UNPIVOT ์ ˆ ์ œ8์ ˆ ์ •๊ทœ ํ‘œํ˜„์‹ ์žฅ ์š”์•ฝ ์—ฐ์Šต๋ฌธ์ œ โœจ์ œ1์ ˆ ์„œ๋ธŒ ์ฟผ๋ฆฌ(Subquery) ์„œ๋ธŒ์ฟผ๋ฆฌ๋ž€? ์„œ๋ธŒ ์ฟผ๋ฆฌ ์ข…๋ฅ˜ ์„ค๋ช… Un-Correlated(๋น„์—ฐ๊ด€) ์„œ๋ธŒ ์ฟผ๋ฆฌ ์„œ๋ธŒ ์ฟผ๋ฆฌ๊ฐ€ ๋ฉ”์ธ ์ฟผ๋ฆฌ ์นผ๋Ÿผ์„ ๊ฐ–๊ณ  ์žˆ์ง€ ์•Š๋Š” ํ˜•ํƒœ์˜ ์„œ๋ธŒ ์ฟผ๋ฆฌ๋‹ค. ๋ฉ”์ธ ์ฟผ๋ฆฌ์— ๊ฐ’(์„œ๋ธŒ์ฟผ๋ฆฌ๊ฐ€ ์‹คํ–‰๋œ ๊ฒฐ๊ณผ)์„ ์ œ๊ณตํ•˜๊ธฐ ์œ„ํ•œ ๋ชฉ์ ์œผ๋กœ ์ฃผ๋กœ ์‚ฌ์šฉํ•œ๋‹ค. Correlated(์—ฐ๊ด€) ์„œ๋ธŒ ์ฟผ๋ฆฌ ์„œ๋ธŒ ์ฟผ๋ฆฌ๊ฐ€ ๋ฉ”์ธ ์ฟผ๋ฆฌ ์นผ๋Ÿผ์„ ๊ฐ–๊ณ  ์žˆ๋Š” ํ˜•ํƒœ์˜ ์„œ๋ธŒ ์ฟผ๋ฆฌ๋‹ค. ์ผ๋ฐ˜์ ์œผ๋กœ ๋ฉ”์ธ ์ฟผ๋ฆฌ๊ฐ€ ๋จผ์ € ์ˆ˜ํ–‰๋ผ ์ฝํ˜€์ง„ ๋ฐ์ดํ„ฐ๋ฅผ ์„œ๋ธŒ ์ฟผ๋ฆฌ์—์„œ ์กฐ๊ฑด์ด ๋งž๋Š”์ง€ ํ™•์ธํ•˜๊ณ ์ž ํ•  ๋•Œ ์ฃผ๋กœ ์‚ฌ์šฉํ•œ๋‹ค. .. 2022. 4. 14.
300x250

์ฝ”๋“œ