oracle 数的构建
select lpad(' ',4*(level-1))||t.EQU_NAME AS EQU_NAME ,
t.PARENT_ID,
t.equ_id
from T_EQU_INFO_TEST t
start with t.equ_id IN
(SELECT equ_id FROM T_EQU_INFO_TEST WHERE parent_ID IS NULL AND
ORGAN_ID= '200511171119415510' )
connect by prior EQU_ID=PARENT_ID