Oracle树查询(查询所有子节点包含自己)

查询 某ID 所有的子孙包含自己：

　　

 select * from tableName t
    start with t.pid = '2c948a836b4f94b4016b5000c386014b'
            or t.id = '2c948a836b4f94b4016b5000c386014b'
   connect by t.pid = prior t.id