Oracle递归查询所有叶子节点

语法：

 SELECT ... 
 FROM ...
 	[WHERE condition]                         --过滤某些节点
	[START WITH [nocycle] start_condition]    --定义查询的起点, 可以使用子查询
	CONNECT BY [[nocycle] PRIOR COLUMN1 = COLUMN2 [AND ...]];   --定义父子关系
order [ sibilings ] by ...

查询标签ID为 abc123 的子节点 及 所有叶子节点

SELECT
	*
FROM
	NLP_LABEL_LIBRARY nll
WHERE nll.DEL_FLAG = 0
START WITH
	nll.LABEL_LIBRARY_ID = 'abc123'
CONNECT BY
	PRIOR nll.LABEL_LIBRARY_ID =  nll.SUPER_LABEL

PRIOR 写等号前面是往下找子节点、写后面是往上查询所有的父节点

参考：Oracle的Connect By用法及理解