<\/p>\n
\uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4 scott\uc720\uc800\uc758 emp\ud14c\uc774\ube14\uc744 \ubcf4\uba74 empno\uc640 mgr\uceec\ub7fc\uc774 \uc788\uc2b5\ub2c8\ub2e4.
\nmgr \uceec\ub7fc\uc758 \ub370\uc774\ud130\ub294 \ud574\ub2f9 \uc0ac\uc6d0\uc758 \uad00\ub9ac\uc790\uc758 empno\ub97c \uc758\ubbf8 \ud569\ub2c8\ub2e4.
\n\uc608\ub97c \ub4e4\uc5b4\uc11c \uc544\ub798\uc758 \ub370\uc774\ud130\ub97c \ubcf4\uba74\uc740..<\/p>\n
\r\n EMPNO ENAME SAL MGR\r\n ------ --------- ------- ----------\r\n 7369 SMITH 800 7902\r\n 7902 FORD 3000 7566\r\n<\/pre>\nempno 7369\uc0ac\uc6d0\uc758 \uad00\ub9ac\uc790\ub294 7902\uc758 empno\ub97c \uac00\uc9c4 \uc0ac\uc6d0\uc774\uba70
\nempno 7902\uc0ac\uc6d0\uc758 \uad00\ub9ac\uc790\ub294 7566\uc758 empno\ub97c \uac00\uc9c4 \uc0ac\uc6d0\uc785\ub2c8\ub2e4. <\/p>\n\uc774\ub7f0 \uc0c1\uc704 \uacc4\uce35\uacfc \ud558\uc704\uacc4\uce35\uc758 \uad00\uacc4\ub97c \uc624\ub77c\ud074\uc5d0\uc11c\ub294 START WITH\uc640 CONNECT BY\ub97c \uc774\uc6a9\ud574\uc11c \uc27d\uac8c \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n\uc0c1\ud488\uc758 \uce74\ud14c\uace0\ub9ac(\ub300\ubd84\ub958,\uc911\ubd84\ub958,\uc18c\ubd84\ub958…)\ub97c \uc870\ud68c \ud560\ub54c START WITH\uc640 CONNECT BY\ub97c \uc774\uc6a9\ud558\uba74 \ud2b8\ub9ac \uad6c\uc870\ub85c \ud3b8\ub9ac\ud558\uac8c \uc870\ud68c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n\uac8c\uc2dc\ud310\uc5d0\uc11c\uc758 \uc77c\ubc18\uae00\uacfc \ub2f5\ubcc0\uae00 \uacfc\uc758 \uad00\uacc4\uc5d0\uc11c\ub3c4 \uc0ac\uc6a9 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\u2299 START WITH\uc640 CONNECT BY\ub97c \uc774\uc6a9\ud574 \ub370\uc774\ud130\ub97c \uacc4\uce35\uc801\uc778 \uc21c\uc11c\ub85c \uc870\ud68c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n
\u25c8 START WITH
\n – \uacc4\uce35 \uc9c8\uc758\uc758 \ub8e8\ud2b8(\ubd80\ubaa8\ud589)\ub85c \uc0ac\uc6a9\ub420 \ud589\uc744 \uc9c0\uc815 \ud569\ub2c8\ub2e4..
\n – \uc11c\ube0c\ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\u25c8 CONNECT BY
\n – \uc774 \uc808\uc744 \uc774\uc6a9\ud558\uc5ec \uacc4\uce35 \uc9c8\uc758\uc5d0\uc11c \uc0c1\uc704\uacc4\uce35(\ubd80\ubaa8\ud589)\uacfc \ud558\uc704\uacc4\uce35(\uc790\uc2dd\ud589)\uc758 \uad00\uacc4\ub97c \uaddc\uc815 \ud569\ub2c8\ub2e4.
\n – \ubcf4\ud1b5 PRIOR \uc5f0\uc0b0\uc790\ub97c \ub9ce\uc774 \uc0ac\uc6a9 \ud569\ub2c8\ub2e4..
\n – \uc11c\ube0c\ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.. <\/p>\n\u25c8 CONNECT BY\uc758 \uc2e4\ud589\uc21c\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.
\n – \uccab\uc9f8 START WITH\uc808
\n – \ub458\uc9f8 CONNECT BY \uc808
\n – \uc138\uc9f8 WHERE \uc808 \uc21c\uc11c\ub85c \ud480\ub9ac\uac8c \ub418\uc5b4\uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\uc608\uc81c1)\uc0c1\uc704\uacc4\uce35\uacfc \ud558\uc704 \uacc4\uce35 \uad00\uacc4\uc758 \uc21c\uc11c\ub300\ub85c \ucffc\ub9ac\ud574 \uc634
\nLEVEL \uc608\uc57d\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec depth\ub97c \ud45c\ud604 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n\uc9c1\uc5c5\uc774 PRESIDENT\uc744 \uae30\uc900\uc73c\ub85c \uacc4\uce35 \uad6c\uc870\ub85c \uc870\ud68c\ud569\ub2c8\ub2e4. <\/p>\nSQL> SELECT LEVEL,empno,ename, mgr\r\n FROM emp\r\n START WITH job = 'PRESIDENT' -- \uc9c1\uc5c5\uc774 PRESIDENT\ub97c \uae30\uc900\uc73c\ub85c\r\n CONNECT BY PRIOR empno = mgr; -- \uc0ac\uc6d0(empno)\uacfc \uad00\ub9ac\uc790(mgr)\uc758 \uad00\uacc4\ub97c \uacc4\uce35 \uad6c\uc870\ub85c \uc870\ud68c\r\n \r\n LEVEL EMPNO ENAME MGR\r\n--------- ---------- -------------------- ----------\r\n 1 7839 KING\r\n 2 7566 JONES 7839\r\n 3 7788 SCOTT 7566 \r\n 4 7876 ADAMS 7788 \r\n 3 7902 FORD 7566\r\n 4 7369 SMITH 7902\r\n 2 7698 BLAKE 7839\r\n 3 7499 ALLEN 7698\r\n 3 7521 WARD 7698\r\n 3 7654 MARTIN 7698\r\n 3 7844 TURNER 7698\r\n 3 7900 JAMES 7698\r\n 2 7782 CLARK 7839\r\n 3 7934 MILLER 7782<\/pre>\nLEVEL\uceec\ub7fc\uc740 depth\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4.
\nJONES\uc758 \uad00\ub9ac\uc790\ub294 KING\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4.
\nSCOTT\uc758 \uad00\ub9ac\uc790\ub294 JONES\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4.
\n\uc608\uc81c\uc640 \uac19\uc774 \uc0c1\/\ud558\uc758 \uacc4\uce35 \uad6c\uc870\ub97c \uc27d\uac8c \uc870\ud68c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\uc608\uc81c2) \uc0ac\uc6d0\uc131\uba85\uc744 \uacc4\uce35 \uad6c\uc870\ub85c \ubcf4\uc5ec \uc90c<\/p>\n
SQL>SET LINESIZE 100\r\nSQL>SET PAGESIZE 100\r\nSQL>COL ename FORMAT A20\r\n\r\n -- \uc608\uc81c1\uc758 \uacb0\uacfc\ub97c \uac00\uc9c0\uace0 LPAD\ud568\uc218\ub97c \uc774\uc6a9\ud574\uc11c ename\uc67c\ucabd\uc5d0 \uacf5\ubc31\uc744 \ucd94\uac00 \ud588\uc2b5\ub2c8\ub2e4. \r\nSQL>SELECT LPAD(' ', 4*(LEVEL-1)) || ename ename, empno, mgr, job \r\n FROM emp\r\n START WITH job='PRESIDENT'\r\n CONNECT BY PRIOR empno=mgr; \r\n\r\n ENAME EMPNO MGR JOB\r\n-------------------- ---------- ---------- ---------\r\nKING 7839 PRESIDENT\r\n JONES 7566 7839 MANAGER\r\n SCOTT 7788 7566 ANALYST\r\n ADAMS 7876 7788 CLERK\r\n FORD 7902 7566 ANALYST\r\n SMITH 7369 7902 CLERK\r\n BLAKE 7698 7839 MANAGER\r\n ALLEN 7499 7698 SALESMAN\r\n WARD 7521 7698 SALESMAN\r\n MARTIN 7654 7698 SALESMAN\r\n TURNER 7844 7698 SALESMAN\r\n JAMES 7900 7698 CLERK\r\n CLARK 7782 7839 MANAGER\r\n MILLER 7934 7782 CLERK<\/pre>\n\uc608\uc81c3) \ub808\ubca8\uc774 2\uae4c\uc9c0\ub9cc \ucffc\ub9ac\ud574\uc11c \uac00\uc838\uc624\ub294 \uc608\uc81c<\/p>\n
SQL>SELECT LPAD(' ', 4*(LEVEL-1)) || ename ename, empno, mgr, job \r\n FROM emp\r\n START WITH job='PRESIDENT'\r\n CONNECT BY PRIOR empno=mgr \r\n AND LEVEL <=2 ; \r\n \r\nENAME EMPNO MGR JOB\r\n-------------------- ---------- ---------- ---------\r\nKING 7839 PRESIDENT\r\n JONES 7566 7839 MANAGER\r\n BLAKE 7698 7839 MANAGER\r\n CLARK 7782 7839 MANAGER <\/pre>\n\uc608\uc81c4) \uac01 label\ubcc4\ub85c \uae09\uc5ec\uc758 \ud569\uacfc \uc778\uc6d0\uc218\ub97c \uad6c\ud558\ub294 \uc608\uc81c<\/p>\n
SQL> SELECT LEVEL, SUM(sal) total,COUNT(empno) cnt\r\n FROM emp\r\n START WITH job='PRESIDENT' \r\n CONNECT BY PRIOR empno=mgr \r\n GROUP BY LEVEL \r\n ORDER BY LEVEL; \r\n \r\n LEVEL TOTAL CNT\r\n---------- ---------- ----------\r\n 1 5000 1\r\n 2 8275 3\r\n 3 13850 8\r\n 4 1900 2<\/pre>\n\u25c8 \ub370\uc774\ud130\uac00 \ub9ce\uc544\uc9c8 \uacbd\uc6b0….
\n– \uccab\uc9f8\ub85c \ud480\ub9ac\ub294 START WITH job=’PRESIDENT’ job \uceec\ub7fc\uc5d0 index\uac00 \uc0dd\uc131\ub418\uc5b4 \uc788\uc9c0 \uc54a\ub294\ub2e4\uba74 \uc18d\ub3c4\ub97c \ubcf4\uc7a5\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.
\n– \uadf8\ub9ac\uace0 \ub458\uc9f8\ub85c \ud480\ub9ac\ub294 CONNECT BY PRIOR empno = mgr \uc5ed\uc2dc PRIOR \ucabd\uc758 \uceec\ub7fc\uac12\uc774 \uc0c1\uc218\uac00 \ub418\uae30 \ub54c\ubb38\uc5d0 MGR\uceec\ub7fc\uc5d0 index\ub97c \uc0dd\uc131\ud558\uc5ec\uc57c CONNECT BY\uc758 \uc18d\ub3c4\ub97c \ubcf4\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n– \uacc4\uce35\uad6c\uc870\ub97c CONNECT BY, START WITH\ub85c \ud480\uba74 \ubd80\ubd84\ubc94\uc704 \ucc98\ub9ac\uac00 \ubd88\uac00\ub2a5\ud558\uace0 Desc\uc73c\ub85c \ud45c\ud604\ud558\uae30\uac00 \uc5b4\ub835\uc2b5\ub2c8\ub2e4.<\/p>\n<\/p>\n","protected":false},"excerpt":{"rendered":"
\uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4 scott\uc720\uc800\uc758 emp\ud14c\uc774\ube14\uc744 \ubcf4\uba74 empno\uc640 mgr\uceec\ub7fc\uc774 \uc788\uc2b5\ub2c8\ub2e4. mgr \uceec\ub7fc\uc758 \ub370\uc774\ud130\ub294 \ud574\ub2f9 \uc0ac\uc6d0\uc758 \uad00\ub9ac\uc790\uc758 empno\ub97c \uc758\ubbf8 \ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4\uc11c \uc544\ub798\uc758 \ub370\uc774\ud130\ub97c \ubcf4\uba74\uc740.. EMPNO ENAME SAL MGR —— ——— ——- ———- 7369 SMITH 800 7902 7902 FORD 3000 7566 empno … Continue reading