【Oracle】树查询(select...start with... connect by ...prior/connect_by_isleaf)
1.表数据:UP_COMPLAINT_CODE为该数据的父节点id2.构建树形结构查询SELECT LPAD (' ', LEVEL * 3, ' ') || COMPLAINT_NAME, COMPLAINT_CODE, UP_COMPLAINT_CODE FROM tablenameSTART WITH UP_COMPLAINT_...
原创
2020-04-15 17:12:42 ·
270 阅读 ·
0 评论