Shulou(Shulou.com)06/01 Report--

ORACLE database recursively queries all children's data of the current data (excluding itself)

SELECT id AS id, parent_id AS parentId, parent_id AS parent, name AS textFROM mdm_center START WITH parent_id = # {parentId} CONNECT BY prior id = parent_id

ORACLE database queries all the parent data of the current data (including its own)

SELECT id AS id, parent_id AS parentId, parent_id AS parent, name AS textFROM mdm_center START WITH id = # {centerId} CONNECT BY prior parent_id = id

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.