oracle 递归查询sql

1.包括根节点： 

select postname from jxd7_rm_post start with postid = ? connect by prior postid = parentid;

2.不包括根节点：

select postname from jxd7_rm_post start with parentid = ? connect by prior postid = parentid