728x90
๋ฐ˜์‘ํ˜•

์ „์ฒด ๊ธ€ 1376

[DB][Oracle] DECODE

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DECODE.html SQL Language Reference docs.oracle.com DECODE๋Š” Oracle SQL์—์„œ ์กฐ๊ฑด์— ๋”ฐ๋ผ ๋‹ค๋ฅธ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•˜๋Š” ๋ฐ ์‚ฌ์šฉ๋˜๋Š” ํ•จ์ˆ˜์ž…๋‹ˆ๋‹ค.๊ฐ„๋‹จํ•˜๊ฒŒ ์„ค๋ช…ํ•˜๋ฉด, ํŠน์ • ๊ฐ’์ด ์กฐ๊ฑด์— ๋งž์œผ๋ฉด ๊ทธ์— ํ•ด๋‹นํ•˜๋Š” ๊ฒฐ๊ณผ๋ฅผ ๋ฐ˜ํ™˜ํ•˜๊ณ ,๊ทธ๋ ‡์ง€ ์•Š์œผ๋ฉด ๊ธฐ๋ณธ๊ฐ’์ด๋‚˜ ๋‹ค๋ฅธ ์กฐ๊ฑด์— ๋”ฐ๋ฅธ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.DECODE๋Š” CASE ๋ฌธ์˜ ๊ฐ„๋‹จํ•œ ํ˜•ํƒœ๋กœ ์ƒ๊ฐํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. DECODE(ํ‘œํ˜„์‹, ์กฐ๊ฑด1, ๊ฒฐ๊ณผ1, ์กฐ๊ฑด2, ๊ฒฐ๊ณผ2, ..., ์กฐ๊ฑดN, ๊ฒฐ๊ณผN, ๊ธฐ๋ณธ๊ฐ’) ํ‘œํ˜„์‹: ๋น„๊ตํ•  ๊ฐ’์ž…๋‹ˆ๋‹ค.์กฐ๊ฑด1, ์กฐ๊ฑด2, ..., ์กฐ๊ฑดN: ํ‘œํ˜„์‹๊ณผ ๋น„๊ตํ•  ๊ฐ’์ž…๋‹ˆ๋‹ค.๊ฒฐ๊ณผ1, ๊ฒฐ๊ณผ2, ..., ๊ฒฐ..

DB 2024.08.05

String to UUID/ UUID to String

import java.nio.charset.StandardCharsets;import java.security.MessageDigest;import java.security.NoSuchAlgorithmException;import java.util.UUID;public class UUIDExample { public static void main(String[] args) { // ์ˆซ์ž ID๋ฅผ ๋ฌธ์ž์—ด๋กœ ๋ณ€ํ™˜ String name = "128478"; // ๋„ค์ž„์ŠคํŽ˜์ด์Šค UUID (์˜ˆ: URL ๋„ค์ž„์ŠคํŽ˜์ด์Šค) UUID namespace = UUID.fromString("6ba7b811-9dad-11d1-80b4-00c04fd430c8"); ..

IT์ง€์‹ 2024.08.04

[Eclipse] Gradle๊ณผ "Add Spring Project Nature"์˜ ๊ด€๊ณ„

Gradle ์„ค์ •:Gradle๋กœ Spring ํ”„๋กœ์ ํŠธ๋ฅผ ์„ค์ •ํ•  ๋•Œ, build.gradle ํŒŒ์ผ์—์„œ ํ•„์š”ํ•œ Spring ์ข…์†์„ฑ์„ ์ถ”๊ฐ€ํ•˜๊ณ  ์„ค์ •ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.Spring Boot ํ”„๋กœ์ ํŠธ์˜ ๊ฒฝ์šฐ, spring-boot-starter ์ข…์†์„ฑ ๋“ฑ์„ ์ถ”๊ฐ€ํ•˜๊ณ , Gradle์˜ ํ”Œ๋Ÿฌ๊ทธ์ธ์„ ์‚ฌ์šฉํ•ด ๋นŒ๋“œ์™€ ์‹คํ–‰์„ ๊ด€๋ฆฌํ•ฉ๋‹ˆ๋‹ค.์˜ˆ๋ฅผ ๋“ค์–ด, ๊ธฐ๋ณธ์ ์ธ Spring Boot ํ”„๋กœ์ ํŠธ ์„ค์ •์€ ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค:plugins { id 'org.springframework.boot' version '2.7.0' id 'io.spring.dependency-management' version '1.0.11.RELEASE' id 'java'}group = 'com.example'version = '0.0.1-SNAPSH..

IT์ง€์‹ 2024.08.03

[Eclipse] ์ดํด๋ฆฝ์Šค - Spring > Add Spring Project Nature

"Add Spring Project Nature"๋Š” Eclipse IDE์—์„œ ์ผ๋ฐ˜์ ์ธ Java ํ”„๋กœ์ ํŠธ๋ฅผ Spring ํ”„๋กœ์ ํŠธ๋กœ ๋ณ€ํ™˜ํ•˜๋Š” ๊ธฐ๋Šฅ์ž…๋‹ˆ๋‹ค. ์ด ์ž‘์—…์„ ์ˆ˜ํ–‰ํ•˜๋ฉด ํ”„๋กœ์ ํŠธ์— Spring ๊ด€๋ จ ๊ตฌ์„ฑ ์š”์†Œ๋ฅผ ์ถ”๊ฐ€ํ•˜๊ณ , Spring Framework์™€์˜ ํ†ตํ•ฉ์„ ์‰ฝ๊ฒŒ ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์ด๋ฅผ ํ†ตํ•ด Spring์˜ ๋‹ค์–‘ํ•œ ๊ธฐ๋Šฅ, ์˜ˆ๋ฅผ ๋“ค์–ด ์˜์กด์„ฑ ์ฃผ์ž…, ๋ฐ์ดํ„ฐ ์•ก์„ธ์Šค, ํŠธ๋žœ์žญ์…˜ ๊ด€๋ฆฌ ๋“ฑ์„ ๋” ์‰ฝ๊ฒŒ ํ™œ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.๋‹ค์Œ์€ "Add Spring Project Nature"๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ Eclipse์—์„œ Java ํ”„๋กœ์ ํŠธ๋ฅผ Spring ํ”„๋กœ์ ํŠธ๋กœ ๋ณ€ํ™˜ํ•˜๋Š” ์ผ๋ฐ˜์ ์ธ ์ ˆ์ฐจ์ž…๋‹ˆ๋‹ค:Eclipse์—์„œ ํ”„๋กœ์ ํŠธ ์„ ํƒ: Eclipse์—์„œ ๋ณ€ํ™˜ํ•˜๋ ค๋Š” Java ํ”„๋กœ์ ํŠธ๋ฅผ ์„ ํƒํ•ฉ๋‹ˆ๋‹ค.ํ”„๋กœ์ ํŠธ ์ปจํ…์ŠคํŠธ ๋ฉ”๋‰ด ์—ด๊ธฐ: ํ”„๋กœ์ ํŠธ๋ฅผ ๋งˆ์šฐ์Šค..

IT์ง€์‹ 2024.08.02

Ai ํŒŒ์ผ vs JPG ํŒŒ์ผ

์›น ํŽ˜์ด์ง€์˜ ๋กœ๊ณ ๋ฅผ ๋ณ€๊ฒฝํ•ด์ฃผ์–ด์•ผ ํ•˜๋Š”๋ฐ,๋‹ค์šด๋กœ๋“œ ๊ฐ€๋Šฅํ•œ ํŒŒ์ผ์˜ ์–‘์‹์ด ai ํŒŒ์ผ๊ณผ jpg ํŒŒ์ผ ์ด์—ˆ๋‹ค. AI ํŒŒ์ผ๊ณผ JPG ํŒŒ์ผ์€ ์„œ๋กœ ๋‹ค๋ฅธ ๋‘ ๊ฐ€์ง€ ์ด๋ฏธ์ง€ ํŒŒ์ผ ํ˜•์‹์œผ๋กœ, ๊ฐ๊ฐ์˜ ํŠน์„ฑ๊ณผ ์šฉ๋„๊ฐ€ ๋‹ค๋ฆ…๋‹ˆ๋‹ค. ์•„๋ž˜๋Š” ์ด ๋‘ ํ˜•์‹์˜ ์ฃผ์š” ์ฐจ์ด์ ์ž…๋‹ˆ๋‹ค.AI ํŒŒ์ผ (Adobe Illustrator Artwork)ํ˜•์‹: ๋ฒกํ„ฐ ๊ทธ๋ž˜ํ”ฝ๋ฒกํ„ฐ ๊ทธ๋ž˜ํ”ฝ์€ ์ , ์„ , ๋„ํ˜• ๋“ฑ์„ ์ˆ˜ํ•™์  ๊ณต์‹์„ ์‚ฌ์šฉํ•ด ์ •์˜ํ•˜๋ฉฐ, ์ด๋ฏธ์ง€ ํฌ๊ธฐ๋ฅผ ์กฐ์ •ํ•ด๋„ ํ’ˆ์งˆ์ด ์†์‹ค๋˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค.ํ”„๋กœ๊ทธ๋žจ: Adobe IllustratorAI ํŒŒ์ผ์€ Adobe Illustrator๋ฅผ ํฌํ•จํ•œ ์ผ๋ถ€ ๋ฒกํ„ฐ ๊ทธ๋ž˜ํ”ฝ ์†Œํ”„ํŠธ์›จ์–ด์—์„œ ์ฃผ๋กœ ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค.์šฉ๋„: ๋กœ๊ณ , ์ผ๋Ÿฌ์ŠคํŠธ, ๋””์ž์ธ ์ž‘์—…๋ฒกํ„ฐ ํ˜•์‹์€ ์ฃผ๋กœ ๋กœ๊ณ , ์•„์ด์ฝ˜, ์ผ๋Ÿฌ์ŠคํŠธ ๋“ฑ ๋‹ค์–‘ํ•œ ๊ทธ๋ž˜ํ”ฝ ๋””์ž์ธ์— ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค.ํŒŒ์ผ ํฌ๊ธฐ: ์ƒ..

IT์ง€์‹ 2024.08.01

[Error][Oracle][Dbeaver] ORA-01442: ๋ณ€๊ฒฝํ•˜๊ณ ์ž ํ•˜๋Š” ์—ด์ด ์ด๋ฏธ NOT NULL์ž…๋‹ˆ๋‹ค

DB์ƒ์„ฑํ•˜๋ฉด์„œ alter tableํ•˜๋Š” ๊ฒƒ์„ DBeaver๋ฅผ ์‚ฌ์šฉํ•ด์„œ ์ž๋™์œผ๋กœ SQL๋ฌธ์„ ์ƒ์„ฑํ•ด์ค€ ๊ฒƒ์„ ์‹คํ–‰์‹œ์ผฐ๋”๋‹ˆํ•ด๋‹น ์˜ค๋ฅ˜๊ฐ€ ๋‚ฌ๊ณ , ์ด๋ฏธ not null ์„ค์ •์ด ๋˜์–ด์žˆ๋Š” ์ปฌ๋Ÿผ์— ๋˜ not null์„ ์„ค์ •ํ•ด์ฃผ๋ ค๊ณ  ํ•˜๋‹ˆ ์—๋Ÿฌ๊ฐ€ ๋‚ฌ๋‹ค.์ฟผ๋ฆฌ๋ฅผ ๋ณต์‚ฌํ•˜์—ฌ not null ๋ถ€๋ถ„์„ ์‚ญ์ œํ•ด์ฃผ๊ณ  ์ฟผ๋ฆฌ์‹คํ–‰ํ•˜๋‹ˆ ์„ฑ๊ณต

Error 2024.07.31

[Error][Oracle]ORA-02437: (*)์„ ๊ฒ€์ฆํ•  ์ˆ˜ ์—†์Šต๋‹ˆ๋‹ค - ์ž˜๋ชป๋œ ๊ธฐ๋ณธ ํ‚ค์ž…๋‹ˆ๋‹ค

primarykey๋ฅผ DB์ƒ์„ฑ ์ดํ›„์— ์„ค์ •์„ ์‹œ์ผœ์ฃผ๋ ค๊ณ  ํ•˜์˜€๋Š”๋ฐ,์„ค์ •ํ•˜๊ธฐ์ „์— ๋“ค์–ด๊ฐ€์žˆ๋˜ ๋ฐ์ดํ„ฐ๊ฐ€ ์žˆ์—ˆ๋˜ ๊ฒƒ์ด๋‹ค.๊ธฐ์กด ๋ฐ์ดํ„ฐ์— pkํ•ญ๋ชฉ์— ์ค‘๋ณต๊ฐ’์ด ๋“ค์–ด๊ฐ€์žˆ์–ด์„œ,๊ธฐ์กด๋ฐ์ดํ„ฐ๋ฅผ pk ๋ฃฐ์— ๋งž๊ฒŒ ๋ณ€๊ฒฝํ•ด์ฃผ๊ณ  ์„ค์ •ํ•ด์ฃผ๋‹ˆ ์„ฑ๊ณต๋˜์—ˆ๋‹ค.

Error 2024.07.30

[js] event.target / event.currentTarget

https://velog.io/@sunkim/Javascript-e.target%EA%B3%BC-e.currentTarget%EC%9D%98-%EC%B0%A8%EC%9D%B4%EC%A0%90 [Javascript] e.target๊ณผ e.currentTarget์˜ ์ฐจ์ด์ ๋ธ”๋กœ๊ทธ๋ฅผ ๋ณด๋ฉด์„œ ํƒ€์ž…์Šคํฌ๋ฆฝํŠธ๋ฅผ ๊ณต๋ถ€ํ•˜๋‹ค๊ฐ€ e.target๊ณผ e.currentTarget์ด ๋‹ค๋ฅด๋‹ค๋Š” ๊ฒƒ์„ ์•Œ๊ณ , ๋ฌด์—‡์ด ์–ด๋–ป๊ฒŒ ๋‹ค๋ฅธ์ง€ ๊ฐœ๋…์„ ์ดํ•ดํ•˜๊ณ ์ž ์ •๋ฆฌํ•ด๋ณธ๋‹ค.event.currentTarget == the element to which the event handlevelog.io

Front/JS & jQuery 2024.07.28
728x90
๋ฐ˜์‘ํ˜•