树形结构数据查找某一节点(包含该节点)上所有子节点的sql

select  t.*        from           (            select t.*, sys_connect_by_path(n,'/') np , sys_connect_by_path(id,'/') ip,connect_by_isleaf            from test t             connect by prior t.id=t.parent            --start with t.parent is not null           ) t            where t.ip like '%2%'