반응형

http://blog.naver.com/nanandayo?Redirect=Log&logNo=60094984184

http://blog.naver.com/xxeno?Redirect=Log&logNo=150073442665

계층형 쿼리 ( START WITH ..... CONNECT BY PRIOR ) ORACLE
http://www.cyworld.com/ajkwin79/2741234

SELECT LEVEL, EMPNO, MGR

  FROM  EMP

START  WITH MGR IS NULL

CONNECT BY PRIOR EMPNO = MGR;

http://cyhome.cyworld.com/?home_id=a1672930&postSeq=1882815

반응형

'데이터베이스 > Oracle' 카테고리의 다른 글

Orange for Oracle 단축키  (0) 2019.01.28
[oracle]GREATEST, LEAST 함수  (0) 2018.06.22
Oracle 달력 쿼리  (0) 2016.10.13
[오라클]그룹별 순번 만들기  (0) 2013.06.21
[오라클]유저생성  (0) 2013.04.09

+ Recent posts