oracle递归寻找父节点

create table MEUM_TEST
(
  cid         NUMBER,
  cname       VARCHAR2(32),
  parent_id   NUMBER,
  create_time DATE,
  org_level   NUMBER
);
-- Add comments to the table 
comment on table MEUM_TEST
  is '机构组织简化表';
-- Add comments to the columns 
comment on column MEUM_TEST.cid
  is '主键ID';
comment on column MEUM_TEST.cname
  is '组织名称';
comment on column MEUM_TEST.parent_id
  is '上级组织ID';
comment on column MEUM_TEST.create_time
  is '创建时间';
comment on column MEUM_TEST.org_level
  is '组织级别';

select sys_connect_by_path(cname,'->'),cname ,org_level
from MEUM_TEST t
--where t.org_level=4
start with parent_id=0
connect by prior t.cid=t.parent_id;

select sys_connect_by_path(cname,'->'),cname ,org_level
from MEUM_TEST t
--where t.org_level=4
start with cname='杭州市'
connect by  t.cid= prior t.parent_id;