当前位置：网站首页>SYS_ CONNECT_ BY_ Path (column, 'char') combined with start with connect by prior

SYS_ CONNECT_ BY_ Path (column, 'char') combined with start with connect by prior

2022-04-23 08:25:00 【beinlife】

Query effect ：



Query statement ：

select  SYS_CONNECT_BY_PATH(departmentname,'>') ,t.departmentname,level  

from hrmdepartment t 

start with departmentname=' New business division '  connect by  prior  id=superId;

【 sentence ：

① from “ New business division “ Start , Tracing from the root node to the child node ; If you want to be a child The node goes back to the root node , Should be ：superId=id;

②level Is the current level of the value , such as ” New business division “ yes 1 Level node ,” Brand marketing headquarters “ yes 2 Level node

③”> New business division > Brand marketing headquarters >B2B> Hotel business “, This is with 【SYS_CONNECT_BY_PATH(column,'char') 】 The only effect

】

版权声明
本文为[beinlife]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230734169197.html

边栏推荐

猜你喜欢

随机推荐