/* 倒序排序, 空值放最后 */
ORDER BY Column desc nulls last
/* 递归查询 */
SELECT * FROM ...
WHERE ...
START WITH ID = '00' --起始节点
CONNECT BY PRIOR ID = PID --从父到子
--CONNECT BY PRIOR PID = ID --从子到父
/* sql优化 */
/* + no_merge(B) */
/* + use_hast(A, B) */
/* 倒序排序, 空值放最后 */
ORDER BY Column desc nulls last
/* 递归查询 */
SELECT * FROM ...
WHERE ...
START WITH ID = '00' --起始节点
CONNECT BY PRIOR ID = PID --从父到子
--CONNECT BY PRIOR PID = ID --从子到父
/* sql优化 */
/* + no_merge(B) */
/* + use_hast(A, B) */