Oracle/CONNECT BY PRIOR 썸네일형 리스트형 CONNECT BY PRIOR Hierarchical Query SQL> CREATE TABLE employee ( 2 employee_id INTEGER, 3 manager_id INTEGER, 4 first_name VARCHAR2(10) NOT NULL, 5 last_name VARCHAR2(10) NOT NULL, 6 title VARCHAR2(20), 7 salary NUMBER(6, 0) 8 ); Table created. SQL> SQL> select * from employee; EMPLOYEE_ID MANAGER_ID FIRST_NAME LAST_NAME TITLE SALARY ----------- ---------- ---------- ---------- -------------------- ---------- 1 0 James Smith CEO 8.. 더보기 이전 1 다음