-- ||是连接符，level可以看成常量 select t.fnum,lpad(' ',3*level-3)||'|-'||fname fname,t.fparent,level lev from m_depart t --start with后面是条件1 start with fparent is null --connect by prior后面是条件2 connect by prior fnum=fparent
-- ||是连接符，level可以看成常量
select t.fnum,lpad(' ',3*level-3)||'|-'||fname fname,t.fparent,level lev
from m_depart t
--start with后面是条件1
start with fparent is null
--connect by prior后面是条件2
connect by prior fnum=fparent
，