2024/08 1
[SQL] Oracle ๊ณ„์ธตํ˜• ์งˆ์˜ (START WITH, CONNECT BY, ORDER SIBLINGS BY, SYS_CONNECT_BY_PATH)

๐Ÿš€ ๊ณ„์ธตํ˜• ์งˆ์˜ (START WITH, CONNECT BY)๊ณ„์ธตํ˜• ์งˆ์˜๋ฅผ ์ด์šฉํ•ด EMP ํ…Œ์ด๋ธ”์—์„œ ์‚ฌ์›๊ฐ„์˜ ์„œ์—ด์„ ์ถœ๋ ฅํ•œ๋‹ค.START WITH์™€ CONNECT BY ์ ˆ์„ ์ด์šฉํ•˜๋ฉด LEVEL์„ ์ถœ๋ ฅํ•  ์ˆ˜ ์žˆ๋‹ค.START WITH ์ ˆ์€ ๋ฃจํŠธ๋…ธ๋“œ๋ฅผ ์ง€์ • CONNECT BY ์ ˆ์€ ๋ถ€๋ชจ๋…ธ๋“œ์™€ ์ž์‹๋…ธ๋“œ ๊ฐ„์˜ ๊ด€๊ณ„๋ฅผ ์ง€์ •์šฐ์„  EMP ํ…Œ์ด๋ธ”์˜ ์ „์ฒด ๋ฐ์ดํ„ฐ๋ฅผ ๋ณด๋ฉด ์•„๋ž˜์™€ ๊ฐ™๋‹ค.์œ„์™€ ๊ฐ™์€ ๋ฐ์ดํ„ฐ๊ฐ€ ์žˆ์„๋•Œ EMPNO์™€ MGR๋ฅผ ๋ณด๋ฉด ์ƒํ•˜๊ด€๊ณ„๋ฅผ ํ™•์ธํ•  ์ˆ˜ ์žˆ๋‹ค. MGR๊ฐ€ ์ƒ์œ„์ด๋‹ค. ์ƒํ•˜๊ด€๊ณ„๋ฅผ ๊ฐ„๋‹จํžˆ ๋‚˜ํƒ€๋‚ด๋ฉด ์•„๋ž˜ ๊ทธ๋ฆผ๊ณผ ๊ฐ™๋‹ค.ํ•˜๋‚˜ ์˜ˆ๋ฅผ ๋“ค์ž๋ฉด KING์€ ๋ฃจํŠธ์ด๊ณ  BLAKE, CLARK, JONES์˜ ๊ฒฝ์šฐ KING์˜ ํ•˜์œ„ ๊ด€๊ณ„๋‹ค. JONES๋ฅผ ๋ณด๋ฉด SCOTT๊ณผ FORD๊ฐ€ ํ•˜์œ„ ๊ด€๊ณ„์ด๋ฉฐ FORD๋ฅผ ๋ณด๋ฉด SMITH๊ฐ€ ํ•˜์œ„ ๊ด€๊ณ„์ธ..
Computer Language/SQL 2024.08.22
1
๋”๋ณด๊ธฐ
๋ฐ˜์‘ํ˜•

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