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

posted on 2012-08-23 13:49  蔡成  阅读(107)  评论(0编辑  收藏  举报

导航