Oracle树查询(查询所有子节点包含自己)
-- Oracle树查询(查询所有子节点包含自己)
SELECT *
FROM tablename t
START WITH t.pid = '2c948a836b4f94b4016b5000c386014b'
OR t.id = '2c948a836b4f94b4016b5000c386014b'
CONNECT BY t.pid = PRIOR t.id
Oracle树查询(查询所有子节点包含自己)
-- Oracle树查询(查询所有子节点包含自己)
SELECT *
FROM tablename t
START WITH t.pid = '2c948a836b4f94b4016b5000c386014b'
OR t.id = '2c948a836b4f94b4016b5000c386014b'
CONNECT BY t.pid = PRIOR t.id