oracle的树型结构查询

select lpad(' ', level, '-') || A, B
  from Table where C = 4
connect by prior A = D start with D is null
 order siblings by A;