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

์˜ค๋ผํด13

์˜ค๋ผํด ๊ตฌ๋ฒ„์ „ ๋‹ค์šด๋กœ๋“œ-2 ์ง€๋‚œ ํฌ์ŠคํŒ…์ด ๊ถ๊ธˆํ•˜์‹œ๋‹ค๋ฉด >>> https://howtomakecode.tistory.com/255 ์˜ค๋ผํด ๊ตฌ๋ฒ„์ „ ๋‹ค์šด๋กœ๋“œ-1 ์˜ค๋ผํด ๊ตฌ๋ฒ„์ „์€ ์ด๊ณณ์—์„œ ๋‹ค์šด๋กœ๋“œ ๊ฐ€๋Šฅํ•ฉ๋‹ˆ๋‹ค. https://edelivery.oracle.com/osdc/faces/SoftwareDelivery https://login-ext.identity.oraclecloud.com/ui/v1/error?signature=GhF%2Fy4%2B3QAGa63tken3PRsPPPSn2gSoxja%2F%2Fqq8sb1dg2Mr%2B%2FhveIUjR howtomakecode.tistory.com setupํŒŒ์ผ์„ ์‹คํ–‰ํ–ˆ๋‹ค๋ฉด cmd ์ฐฝ์ด ์ž ์‹œ ์ผœ์ง€๊ณ  ๋‹ค์Œ ์•Œ๋žŒ์ด ๋œน๋‹ˆ๋‹ค. ์œˆ๋„์šฐ ๋ฒ„์ „๋ณด๋‹ค ์˜ค๋ผํด ๋ฒ„์ „์ด ๋‚ฎ์œผ๋ฉด ์ด๋Ÿฐ ์•Œ๋ฆผ์ด ๋œจ๋Š”๋ฐ ์˜ˆ ๋ˆ„๋ฅด๊ณ  ์ง„ํ–‰ํ•˜๋ฉด.. 2023. 12. 29.
์˜ค๋ผํด ๊ตฌ๋ฒ„์ „ ๋‹ค์šด๋กœ๋“œ-1 ์˜ค๋ผํด ๊ตฌ๋ฒ„์ „์€ ์ด๊ณณ์—์„œ ๋‹ค์šด๋กœ๋“œ ๊ฐ€๋Šฅํ•ฉ๋‹ˆ๋‹ค. https://edelivery.oracle.com/osdc/faces/SoftwareDelivery https://login-ext.identity.oraclecloud.com/ui/v1/error?signature=GhF%2Fy4%2B3QAGa63tken3PRsPPPSn2gSoxja%2F%2Fqq8sb1dg2Mr%2B%2FhveIUjRzAuQsdi1xCnttqt339tJe4797XPka6iu4qeyRVWT1GmACu%2F3un9XVqT6MvjssUwJM8508tcuT44zclfbb6wcq8iGjpCtUTDY%2B6f%2FT7q8kKRyxvbRUms8MqcduPYBY5nfJLdp1d8E5WgCm9XTtGjAq8sG4ebxhnvTT7yDwGkud7Stz%2B.. 2023. 12. 29.
์˜ค๋ผํด ํ”„๋กœ์‹œ์ € ORACLE PROCEDURE ์ „์ฒด ๊ฒ€์ƒ‰ ์˜ค๋ผํด ํ”„๋กœ์‹œ์ € ์ „์ฒด ๊ฒ€์ƒ‰ SELECT * FROM USER_SOURCE WHERE 1=1 AND TYPE = 'PROCEDURE'; 2023. 8. 31.
ORACLE ์˜ค๋ผํด ์ œ์•ฝ์กฐ๊ฑด ํ™•์ธ/์‚ญ์ œ/์ƒ์„ฑ ์ œ์•ฝ์กฐ๊ฑด ํ™•์ธ SELECT * FROM ALL_CONSTRAINTS WHERE TABLE_NAME = 'ํ…Œ์ด๋ธ”๋ช…'; SELECT A.UNIQUENESS, B.* FROM ALL_INDEXES A, ALL_IND_COLUMNS B WHERE A.INDEX_NAME = B.INDEX_NAME AND A.TABLE_NAME='ํ…Œ์ด๋ธ”๋ช…'; ์ œ์•ฝ์กฐ๊ฑด ์‚ญ์ œ ALTER TABLE ํ…Œ์ด๋ธ”๋ช… DROP CONSTRAINT ์ œ์•ฝ์กฐ๊ฑด๋ช… CASCADE; ์ธ๋ฑ์Šค ์ƒ์„ฑ CREATE UNIQUE INDEX PK๋ช… ON ํ…Œ์ด๋ธ”๋ช… (์ปฌ๋Ÿผ๋ช…1, ์ปฌ๋Ÿผ๋ช…2....); PK ์ƒ์„ฑ ALTER TABLE ํ…Œ์ด๋ธ”๋ช… ADD (CONSTRAINT PK๋ช… PRIMARY KEY (์ปฌ๋Ÿผ๋ช…1, ์ปฌ๋Ÿผ๋ช…2....)); 2023. 8. 25.
์ •๊ทœํ™”(NORMALIZATION)๋ž€? ์˜ค๋Š˜์€ SQLD ๊ณผ๋ชฉ > ๋ฐ์ดํ„ฐ ๋ชจ๋ธ๋ง์˜ ์ดํ•ด > ์ •๊ทœํ™”์— ๋Œ€ํ•ด ์•Œ์•„๋ณด๊ฒ ์Šต๋‹ˆ๋‹ค. ์ •๊ทœํ™”์˜ ๊ฐœ๋… ์ด์ƒํ˜„์ƒ์ด ์žˆ๋Š” ๋ฆด๋ ˆ์ด์…˜์„ ๋ถ„ํ•ดํ•ด์„œ ์ด์ƒํ˜„์ƒ์„ ์—†์• ๋Š” ๊ณผ์ • ํ•จ์ˆ˜์  ์ข…์†์„ฑ ๋“ฑ์˜ ์ด๋ก ์— ๊ทผ๊ฑฐํ•ด ์ข€ ๋” ์ž‘์€ ๋‹จ์œ„์˜ ํ…Œ์ด๋ธ”๋กœ ์„ค๊ณ„ํ•˜๋Š” ๊ณผ์ • ์ •๊ทœํ™”๋œ ํ…Œ์ด๋ธ”์€ ๋ฐ์ดํ„ฐ๋ฅผ ์ฒ˜๋ฆฌํ•  ๋•Œ ์†๋„๊ฐ€ ๋นจ๋ผ์งˆ ์ˆ˜๋„ ์žˆ๊ณ  ๋Š๋ ค์งˆ ์ˆ˜๋„ ์žˆ์Šต๋‹ˆ๋‹ค. โ€ป ์ด์ƒํ˜„์ƒ: ๋ถˆํ•„์š”ํ•œ ๋ฐ์ดํ„ฐ ์ค‘๋ณต์œผ๋กœ ์ธํ•ด ๋ฆด๋ ˆ์ด์…˜์— ๋Œ€ํ•œ ๋ฐ์ดํ„ฐ ์‚ฝ์ž…, ์ˆ˜์ •, ์‚ญ์ œ ์—ฐ์‚ฐ์„ ์ˆ˜ํ–‰ํ•  ๋•Œ ๋ฐœ์ƒํ•  ์ˆ˜ ์žˆ๋Š” ๋ถ€์ž‘์šฉ [DB] ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ •๊ทœํ™”์™€ ์ด์ƒ ํ˜„์ƒ (Normalization & Anomaly) ์ •๊ทœํ™”๋ž€ ์ด์ƒ ํ˜„์ƒ์„ ์ œ๊ฑฐํ•˜๊ธฐ ์œ„ํ•ด์„œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ฅผ ์˜ฌ๋ฐ”๋ฅด๊ฒŒ ์„ค๊ณ„ํ•ด ๋‚˜๊ฐ€๋Š” ๊ณผ์ •์ด๋‹ค. ์—ฌ๊ธฐ์„œ ์ด์ƒ ํ˜„์ƒ์ด๋ž€ ๋ถˆํ•„์š”ํ•œ ๋ฐ์ดํ„ฐ ์ค‘๋ณต์œผ๋กœ ์ธํ•ด ๋ฆด๋ ˆ์ด์…˜์— ๋Œ€ํ•œ ๋ฐ์ดํ„ฐ ์‚ฝ์ž…, ์ˆ˜์ •, ์‚ญ์ œ.. 2023. 6. 12.
์˜ค๋ผํด ๋ฐ์ดํ„ฐ ์กฐํšŒ/์‚ฝ์ž…/์‚ญ์ œ/๊ฐฑ์‹  ์ด์ „ ๊ธ€์—์„œ ํ…Œ์ด๋ธ” crud ์ฟผ๋ฆฌ ์‚ฌ์šฉํ•˜๋Š” ๋ฒ•์„ ๋ฐฐ์› ์œผ๋‹ˆ ์ปฌ๋Ÿผ๋ณ„ ๋ฐ์ดํ„ฐ๋ฅผ ์กฐ์ž‘ํ•˜๋Š” ๋ฐฉ๋ฒ•์— ๋Œ€ํ•ด์„œ๋„ ์•Œ์•„๋ณด๊ฒ ์Šต๋‹ˆ๋‹ค. ํ…Œ์ด๋ธ” crud ๊ฐœ๋…์„ ๋ณด๊ณ  ์‹ถ์œผ์‹œ๋‹ค๋ฉด ์ด ๋ถ€๋ถ„์„ ํด๋ฆญํ•˜์‹œ๋ฉด ๋ฉ๋‹ˆ๋‹ค. ๋ฐ์ดํ„ฐ ์กฐํšŒ, ์ˆ˜์ •, ์‚ฝ์ž…, ์‚ญ์ œ ๋ฐฉ๋ฒ•์˜ ํ˜•์‹ ๋ฐ ์˜ˆ์‹œ๋ฅผ ์ ์–ด๋ณด์•˜์Šต๋‹ˆ๋‹ค. ๋ฐ์ดํ„ฐ ์กฐํšŒ SELECT ํ˜•์‹ select ์ปฌ๋Ÿผ๋ช…1, ์ปฌ๋Ÿผ๋ช…2, ... from ์กฐํšŒํ• ํ…Œ์ด๋ธ”๋ช… ์ „์ฒด ๋ฐ์ดํ„ฐ๋ฅผ ์กฐํšŒํ•˜๊ณ  ์‹ถ์€ ๊ฒฝ์šฐ select * from ํ…Œ์ด๋ธ”๋ช… ์˜ˆ์‹œ -- tb_emp ํ…Œ์ด๋ธ”์˜ ์ „์ฒด ๋ฐ์ดํ„ฐ ์กฐํšŒ SELECT * FROM tb_emp; -- tb_emp ํ…Œ์ด๋ธ”์— ์žˆ๋Š” emp_no, emp_nm ๋ฐ์ดํ„ฐ ์กฐํšŒ SELECT emp_no, emp_nm FROM tb_emp; ๊ฒฐ๊ณผ SELECT ๋ฌธ ์ž‘์„ฑ ๊ทœ์น™ ๋”๋ณด๊ธฐ - ๋Œ€๋ฌธ์ž์™€ ์†Œ๋ฌธ์ž๋ฅผ ๊ตฌ๋ถ„ํ•˜์ง€.. 2023. 6. 7.
์˜ค๋ผํด ํ…Œ์ด๋ธ” ์ƒ์„ฑ/์กฐํšŒ/์ˆ˜์ •/์‚ญ์ œ ์˜ค๋ผํด ํ…Œ์ด๋ธ” ์ƒ์„ฑ/์ˆ˜์ •/์‚ญ์ œํ•˜๋Š” ๋ฐฉ๋ฒ•์— ๋Œ€ํ•ด ์•Œ์•„๋ณด๊ฒ ์Šต๋‹ˆ๋‹ค. ์˜ค๋ผํด ํ…Œ์ด๋ธ” ์ƒ์„ฑ CREATE ์—ญํ•  ํ…Œ์ด๋ธ”์˜ ์ƒ์„ฑ ํ˜•์‹ CREATE TABLE [์ƒ์„ฑํ• ํ…Œ์ด๋ธ”๋ช…] (์ปฌ๋Ÿผ๋ช… ๋ฐ์ดํ„ฐํƒ€์ž… ๊ธฐ๋ณธ๊ฐ’ NULL์—ฌ๋ถ€์ฒดํฌ); ์˜ˆ์‹œ CREATE TABLE EMP ( EMPNO NUMBER(4) DEFAULT 1000 NOT NULL, ENAME VARCHAR2(10), ADDRESS VARCHAR2(300), TEL_NO VARCHAR2(10), DEPT_ID NUMBER(2) ); PK ์ƒ์„ฑ -- ALTER TABLE [ํ…Œ์ด๋ธ”๋ช…] ADD CONSTRAINT [PK์ด๋ฆ„] PRIMARY KEY (PK๊ฐ€๋ ์ปฌ๋Ÿผ๋ช…); ALTER TABLE EMP ADD CONSTRAINT EMP_PK PRIMARY KEY (EMPNO); ํ…Œ์ด๋ธ” .. 2023. 6. 7.
์˜ค๋ผํด ๊ด€๋ฆฌ์ž ๊ณ„์ •(SYS) ๋น„๋ฐ€๋ฒˆํ˜ธ ๋ฐ”๊พธ๊ธฐ ๊ด€๋ฆฌ์ž๋กœ ์ ‘์†ํ•ด์•ผ ํ•˜๋Š”๋ฐ ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ์žƒ์–ด๋ฒ„๋ ค ์ ‘์†ํ•  ์ˆ˜ ์—†๋Š”๊ฒฝ์šฐ sqlplus๋กœ ์ ‘์† โ–ผ Enter user-name: sys as sysdba โ–ผ Enter password: ๋นˆ์นธ์œผ๋กœ ๋‘๊ณ  ์—”ํ„ฐ โ–ผ show user โ–ผ ์ด๋ฆ„์ด sys์ธ์ง€ ํ™•์ธํ•˜๊ธฐ โ–ผ alter user sys identified by [๋ฐ”๊พธ๊ณ  ์‹ถ์€ ๋น„๋ฐ€๋ฒˆํ˜ธ]; โ–ผ ๋ณ€๊ฒฝ ์™„๋ฃŒ! 2023. 5. 21.
DB ์—ฐ๊ฒฐ ํ™•์ธ Oracle JDBC.DriverClassName=oracle.jdbc.driver.OracleDriver JDBC.url=jdbc:oracle:thin@URL์ฃผ์†Œ:1521:xe JDBC:Username=๊ณ„์ •๋ช… JDBC:password=๋น„๋ฐ€๋ฒˆํ˜ธ EX) jdbc.driverClassName=oracle.jdbc.driver.OracleDriver jdbc.url=jdbc:oracle:thin:@localhost:1521:xe jdbc.username=id jdbc.password=1234 MySQL JDBC.Driver=com.mysql.jdbc.Driver JDBC.ConnectionURL=jdbc:mysql://URL์ฃผ์†Œ:ํฌํŠธ๋ฒˆํ˜ธ/DB๋ช… JDBC.Username=๊ณ„์ •๋ช… JDBC.Password=๋น„๋ฐ€๋ฒˆํ˜ธ.. 2023. 4. 30.
eclipse์™€ oracldDB ์—ฐ๊ฒฐ ์ดํด๋ฆฝ์Šค์™€ ์˜ค๋ผํด ์—ฐ๋™ ๋ฐฉ๋ฒ• 1. ์ƒ๋‹จ ๋ฉ”๋‰ด์— ์žˆ๋Š” Window - Show View - Data Source Explorer ํด๋ฆญ 2. Database Connections ์—์„œ ์˜ค๋ฅธ์ชฝ ๋งˆ์šฐ์Šค - NEW ํด๋ฆญ 3. Oracle Database๋ฅผ ์‚ฌ์šฉํ•  ๊ฒƒ์ด๋ฏ€๋กœ ORACLE์„ ์„ ํƒ 4. ์ €์žฅ๋œ ๋“œ๋ผ์ด๋ฒ„๊ฐ€ ์—†๋Š” ์ƒํƒœ์ด๋ฏ€๋กœ NEW DRIVER DEFINITION์„ ํด๋ฆญํ•ด ์ƒˆ๋กœ ๋“œ๋ผ์ด๋ฒ„๋ฅผ ์„ค์ • (Drivers ์„ ํƒ์ฐฝ ์˜† ์ดˆ๋ก์ƒ‰๋กœ๊ณ ๋ฅผ ์„ ํƒ) - ORACLE 11 ๋ฒ„์ „ ์“ฐ๊ณ  ์žˆ๋‹ค๋ฉด Oracle Thin Driver 11 ์„ ํด๋ฆญ ์ด๋–„, ๋งŒ์•ฝ OK ๋ฒ„ํŠผ์ด ๋ˆŒ๋ฆฌ์ง€ ์•Š๋Š”๋‹ค๋ฉด JAR List์— ๋ฏธ๋ฆฌ ์ง€์ •๋œ Oracle ๋ฒ„์ „์ด ์žˆ๋Š”์ง€ ํ™•์ธํ•ด์•ผ ํ•œ๋‹ค. ๊ธฐ์กด์— ์ž…๋ ฅ๋˜์–ด ์žˆ๋Š” ๋ฒ„์ „์„ ์ง€์šฐ๊ณ  ํ˜„์žฌ ์ปดํ“จํ„ฐ์— ๊น”๋ ค ์žˆ๋Š” ๋ฒ„์ „ ์„ ํƒ .. 2023. 4. 25.
๋ฐ˜์‘ํ˜•