Database/SQL 12
[Oracle] ๊ณ„์ธตํ˜• ์ฟผ๋ฆฌ(START WITH.. CONNECT BY~)

์ถœ์ฒ˜ : https://docu94.tistory.com/70 https://coding-factory.tistory.com/461 https://tiboy.tistory.com/563 SELECT [์ปฌ๋Ÿผ]... FROM [ํ…Œ์ด๋ธ”] WHERE [์กฐ๊ฑด] START WITH [์ตœ์ƒ์œ„ ์กฐ๊ฑด] CONNECT BY [NOCYCLE][PRIOR ๊ณ„์ธตํ˜• ๊ตฌ์กฐ ์กฐ๊ฑด]; ๊ณ„์ธตํ˜• ๊ตฌ์กฐ๋Š” ์ƒํ•˜ ์ˆ˜์ง๊ด€๊ณ„์˜ ํŠธ๋ฆฌํ˜•ํƒœ์˜ ๊ตฌ์กฐ๋กœ ์ด๋ฃจ์–ด์ง„ ํ˜•ํƒœ๋ฅผ ๋งํ•œ๋‹ค. ์˜ˆ๋ฅผ ๋“ค๋ฉด ํŠน์ •ํšŒ์‚ฌ์˜ ๋ถ€์„œ, ํŠน์ •ํ•™๊ต์˜ ํ•™๊ณผ ๋“ฑ์ด ์žˆ๋‹ค. ๊ณ„์ธตํ˜• ์ฟผ๋ฆฌ๋Š” ํ…Œ์ด๋ธ”์— ์ €์žฅ๋œ ๋ฐ์ดํ„ฐ๋ฅผ ๊ณ„์ธตํ˜• ๊ตฌ์กฐ๋กœ ๋ฐ˜ํ™˜ํ•˜๋Š” ์ฟผ๋ฆฌ๋ฅผ ๋งํ•œ๋‹ค. START WITH์ ˆ์€ ๋ฃจํŠธ๋…ธํŠธ(ํ–‰)์„ ๋ช…์‹œํ•œ๋‹ค. EMP ํ…Œ์ด๋ธ”์„ ํ™•์ธํ•ด๋ณด๋ฉด ํ•ด๋‹น ์‚ฌ์›์˜ ๊ด€๋ฆฌ์ž๊ฐ€ ์žˆ๋‹ค. ๊ทธ ๊ด€๋ฆฌ์ž๊ฐ€ ์ตœ์ข… ๊ด€๋ฆฌ์ž์ผ ์ˆ˜ ์žˆ์ง€๋งŒ ๊ทธ..
Database/SQL 2022.01.17
1 2
๋”๋ณด๊ธฐ

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