sql 语句，递归查询

oracle 递归查询

SELECT
	*
FROM
	FD_PERMISSION
WHERE
	STATUS = 1 
START WITH ID = 1 CONNECT BY pid = PRIOR ID -- 递归查询子节点 
ORDER BY
	PERMISSION_LEVEL,
	PID,
	CRAETE_TIME;