oracle查询机构树

SELECT 
       jgid,jgmc,jgxz,
       LEVEL LVL,
       connect_by_isleaf    
  from tj_base_jg t
 start with jgid =1
connect by parentid = prior jgid;