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

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

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

标签：table   div   color   with   col   from   sele   start   rom